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 thanks. On 29 June 2015 at 15:58, John R Pierce <pie...@hogranch.com> wrote: > On 6/28/2015 10:52 PM, Michael Paquier wrote: > >> Well, yes. It depends on what you want to do then. If this testing >> really requires to promote the standby then you will need to take a >> new fresh base backup knowing that you are using 9.2. >> > > if the standby is running on a file system with snapshotting (like zfs), > and the master is doing WAL archiving, you could, in theory, pause the > replication and snapshot the slave, do read/write tests on the slave, then > restore that snapshot and resume replication, pulling from the WAL archive > til it catches up. > > > > -- > john r pierce, recycling bits in santa cruz > > > > -- > 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]
