- Notifications
You must be signed in to change notification settings - Fork86
Description
Hello! How can I backup from replica? I configured max_wal_senders and hot_standby on the replica. Configured on replica and master in pg_hba.conf:
host replication postgres 0.0.0.0/0 trust
On the master included full_page_writes.
When trying to backup from a replica with the command:
pg_probackup backup -B / data / pgsql / backup --instance pgsql-02 -b FULL -j 4 --master-host = pgsql-02 --master-db = postgres --master-user = postgres --master-port = 5432
I get the error message:
ERROR: WAL segment 000000020000000400000063 could not be archived in 300 seconds
If I specify the IP instead of the name in --master-host, the program will ask for the password forever (although I successfully connect from this machine using psql).
If I delete recovery.conf and run the command:
pg_probackup backup -B / data / pgsql / backup --instance pgsql-02 -b FULL -j 4
The backup will be successfully created.
archive_command on the replica and on the wizard (at the moment backup is configured on the master):
/usr/pgpro-9.6/bin/pg_probackup archive-push -B / data / pgsql / backup --instance pgsql-02 --wal-file-path% p --wal-file-name% f
How should I set up the server in order to successfully make a backup from the replica?