Re: Streaming replication failover process - Pgsql 9.2 - Mailing list pgsql-general

From Patrick B
Subject Re: Streaming replication failover process - Pgsql 9.2
Date
Msg-id CAJNY3itwZY+bCQcZKFF1MXTA7XX-spi1ZPg0oGy3r_uuG3wQ9w@mail.gmail.com
Whole thread Raw
In response to Re: Streaming replication failover process - Pgsql 9.2  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Streaming replication failover process - Pgsql 9.2  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general


2016-07-11 12:18 GMT+12:00 Adrian Klaver <adrian.klaver@aklaver.com>:
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.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Streaming replication failover process - Pgsql 9.2
Next
From: "David G. Johnston"
Date:
Subject: Re: [BUGS] Where clause in pg_dump: need help