Re: Turn off streaming replication - leaving Master running

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Turn off streaming replication - leaving Master running
Date: 2015-06-29 05:58:19
Message-ID: 5590DE7B.3040402@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shujie Shang 2015-06-29 06:24:34 Re: create index on a field of udt
Previous Message Charles Clavadetscher 2015-06-29 05:57:43 Re: create index on a field of udt