0

I have two postgresql nodes, pg-0 and pg-1, master and replica. They are running on different machines with a 25bg/s bandwidth, 8gb ram and an AMD Epyc processor.

Inside i have 6 dbs totaling 1.5gb, so nothing huge.

This is the docker-compose.yaml for pg-1, pg-0 is identical except for the REPMGR_NODE_NETWORK_NAME and REPMGR_NODE_NAME environment variables.

services: pg-1: image: bitnami/postgresql-repmgr:latest container_name: pg-1 restart: unless-stopped volumes: - db-data:/var/lib/postgresql/data - '/home/crminformatica/backup/:/bitnami/backup/' environment: - POSTGRESQL_PASSWORD=postgres - REPMGR_PASSWORD=repmgr - REPMGR_PRIMARY_HOST=pg-0 - REPMGR_NODE_NETWORK_NAME=pg-1 - REPMGR_NODE_NAME=pg-1 - REPMGR_PARTNER_NODES=pg-0,pg-1 ports: - 5432:5432 volumes: db-data:

When starting the replica node, repmgr runs a pg_basebackup, from what i've understand, but it takes 1 hour to complete, which is insane considering the amount of data I have.

I have tried to log the percentage of completion with this repmgr.conf, but it seems to do nothing.

restore_command_options = '--progress --compress=9' log_level = DEBUG log_file = '/var/log/repmgr/repmgr.log'

I have had the same problem with pg_basebackup (without repmgr) and I have tried compression and increasing the number of replica connections but it didn't change.

What can I do?

Improve this question
2
  • Where is the data being backed up to? If the server receiving backup has a low internet speed that could be a reason. Commented Jan 2 at 19:09
  • As I wrote in the post, data in being backed up from a server on the same network with a 25gb/s bandwidth Commented Jan 8 at 16:56

0

Reset to default

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.