If i touch my trigger file and promote my secondary to a master - what effect will that have on the Master - will i need to make any changes on that side ? Will it still try and stream data across to the promoted secondary and just fill up the log files with error messages ?
On 29 June 2015 at 16:50, Michael Paquier <michael.paqu...@gmail.com> wrote: > > > 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 > -- *Andy Erskine* *JDS Australia* *P* 1300 780 432 | *M* 0431919301 | *F* 03 90124578 *E:* *andy.ersk...@jds.net.au <andy.ersk...@jds.net.au>* *W*: www.jds.net.au Level 8, 2 Russell Street, Melbourne, VIC 3000 GPO Box 4777, Melbourne VIC 3001 [image: JDS Signature v1]
