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. On 30 June 2015 at 12:37, Tomas Vondra <tomas.von...@2ndquadrant.com> wrote: > Hi, > > On 06/29/2015 09:27 AM, Andy Erskine wrote: > >> Thanks Jeff, >> >> I don't want a clone - i want to temporaily turn off replication >> (and therefore failover) and load a different db into the secondary >> which is now writable and run some tests. Then i will remove this db >> and run a basebackup to reinstate a copy of the master and turn on >> replication again. >> > > So you want replica and you don't want replica at the same time? > > Is there any reason why you simply don't want to either create a new > snapshot using pg_basebackup, or just simply shut down the standby, create > a copy of the data directory, remove the recovery conf and start it again > as a standalone database? > > regards > > -- > Tomas Vondra http://www.2ndQuadrant.com > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- *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]
