multiple archive_command in PostgreSQL
3
votes
1
answer
1571
views
I have replication with PostgreSQL, so I want to set
archive_command = 'cp %p /var/lib/postgresql/11/main/archive/%f'
but I also want to save WAL files to another safe place: S3.
So is it possible to have multiple archive_command
s? And can I put this command on the slave to push wal files to S3 instead of on the master - I want master to have less performance impact.
Asked by raring-coffee20
(149 rep)
Nov 4, 2019, 04:12 AM
Last activity: Nov 4, 2019, 06:09 AM
Last activity: Nov 4, 2019, 06:09 AM