On Mon, Jun 29, 2015 at 3:34 PM, Andy Erskine <andy(dot)erskine(at)jds(dot)net(dot)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