Sample Header Ad - 728x90

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_commands? 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