From: | basti <mailinglist(at)unix-solution(dot)de> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | DB Backup from WAL Slave |
Date: | 2018-07-24 12:44:45 |
Message-ID: | c5b4fbe7-cd5b-b703-8304-119415572c9a@unix-solution.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)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,
From | Date | Subject | |
---|---|---|---|
Next Message | Sandy Becker | 2018-07-24 13:25:04 | Re: Connections on cluster not being logged |
Previous Message | Michael Paquier | 2018-07-24 05:58:09 | Re: Waiting connections postgres 10 |