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,
