Re: [GENERAL] archive_command not being executed

On 11/10/2017 09:10 AM, Eric D wrote:
> I have a standby db server (SB1) that will soon become the master.  SB1
> is set up with streaming replication from the current master.  I'm
> trying to set up a third server (SB2) as a slave/standby to SB1, so that
> when SB1 becomes the master, there will be a standby for it.  First step
> is to get WAL files shipped from SB1->SB2.

Oh this has happened to me before. :-) On SB1 you need to set
archive_mode to always (not on). Otherwise it is ignored when running as 
a standby.

Btw just in case you are using Ansible here is an unmerged PR for the 
postgres role: https://github.com/ANXS/postgresql/pull/254

Paul


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general