Ok so a question i should have asked at the very beginning .. If i touch my trigger file - promoting the secondary to a master - will that in anyway effect the master thats already running ?
IE no files on the master will change ? Then all i'll have to do is shutdown the secondary when i've finished and run the basebackup process again to restore replication (and change recovery.done - conf again. thanks. On 30 June 2015 at 15:22, Michael Paquier <michael.paqu...@gmail.com> wrote: > > > On Tue, Jun 30, 2015 at 1:39 PM, Andy Erskine <andy.ersk...@jds.net.au> > wrote: > >> No i don't want a replica. >> >> I would like to reconfigure my streaming scenario into two standalone >> db's i don't want the Master to be effected in anyway and i want it running >> consistantly .. the secondary i want to reconfigure as a standalone to load >> a different db and do some testing. >> > When i've finished testing - i want to reconfigure for streaming again. >> > > Well, in this case: > 1) promote your standby > 2) Run your tests on it. > 3) Recreate a new standby > The documentation online, as well as the PostgreSQL wiki have all the > documentation to help you achieve those steps. > Regards, > -- > 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]
