Re: Turn off streaming replication - leaving Master running - Mailing list pgsql-general

From John R Pierce
Subject Re: Turn off streaming replication - leaving Master running
Date
Msg-id 5590DE7B.3040402@hogranch.com
Whole thread Raw
In response to Re: Turn off streaming replication - leaving Master running  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Turn off streaming replication - leaving Master running
List pgsql-general
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



pgsql-general by date:

Previous
From: Andy Erskine
Date:
Subject: Re: Turn off streaming replication - leaving Master running
Next
From: Shujie Shang
Date:
Subject: Re: create index on a field of udt