2016-07-11 12:18 GMT+12:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:
On 07/10/2016 04:28 PM, Patrick B wrote:
archive_command = 'cp %p /var/lib/pgsql/archive/%f'
This would be where?
master server
And does the corresponding restore_command point to the same place?
yes.. the slaves have the restore_command pointing to the same place.
As they won't be able to communicate with master, once all the services are up again, will have to copy them manually
That would be ok right guys?
I will also setup wal_keep_segments to 512
The WAL segments kept would be dependent the number of WAL segments your database generates on average over the worse case downtime interval plus a CYA buffer.
