Hello,
we have a db master and a slave.
master conf:
wal_level = replica
max_wal_senders = 5
wal_keep_segments = 100
archive_mode = on
archive_command = 'rsync -a %p -e "ssh -i
/var/lib/postgresql/.ssh/id_rsa"
postgres@slave:/var/lib/postgresql/9.6/wals/master/%f </dev/null'
slave conf:
# replication
hot_standby = on
# pg_dump: Error message from server: ERROR: canceling statement due to
conflict with recovery
# DETAIL: User was holding a relation lock for too long.
#
https://www.postgresql.org/message-id/CADp-Sm6if-z0NbsxrJwPBQDQNt6AQJpbbagHbWyGrN7zyYZdCA%40mail.gmail.com
max_standby_streaming_delay = 300000
The slave is not used as read-only
But as docu say
(https://www.postgresql.org/docs/9.6/static/runtime-config-wal.html)
wal_level = archive is mapped to replica
How can I do an backup with pg_dumpall from slave?
Best Regards,