On Mon, Jun 29, 2015 at 3:34 PM, Andy Erskine <andy.ersk...@jds.net.au> 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
