Re: Turn off streaming replication - leaving Master running - Mailing list pgsql-general
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 <pierce@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.erskine@jds.net.au
W: www.jds.net.au
Level 8, 2 Russell Street, Melbourne, VIC 3000
GPO Box 4777, Melbourne VIC 3001
Attachment
pgsql-general by date: