Re: Turn off streaming replication - leaving Master running

[Michael Paquier <michael.paquier@xxxxxxxxx>]

On Mon, Jun 29, 2015 at 3:34 PM, Andy Erskine <andy.erskine@xxxxxxxxxx> wrote:

no snapshot available .. i don't mind running basebackup once i've finished my test.

So if someone could help with the steps to turn off replication and bring secondary up as a standalone db that would be great.

How to promote a node: pg_ctl promote or use a trigger_file:

http://www.postgresql.org/docs/devel/static/warm-standby.html#STANDBY-SERVER-OPERATION

Turning temporarily off replication has little meaning if you intend to bring back a new standby afterwards.

My 2c.

--

Michael