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