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

From Michael Paquier
Subject Re: Turn off streaming replication - leaving Master running
Date
Msg-id CAB7nPqSuLDAnqr8Z8FwRYAM-E1ueDdt204GxmrU46YF7FfmtAQ@mail.gmail.com
Whole thread Raw
In response to Turn off streaming replication - leaving Master running  (Andy Erskine <andy.erskine@jds.net.au>)
Responses Re: Turn off streaming replication - leaving Master running
Re: Turn off streaming replication - leaving Master running
List pgsql-general
On Mon, Jun 29, 2015 at 2:42 PM, Andy Erskine <andy.erskine@jds.net.au> wrote:
> I'd like to turn off the streaming on my postgresdb (9.2) It is currently
> setup to stream from master to a single secondary.
>
> I want to shutdown the secondary and turn it into another master and connect
> it to another application for testing - after which i want to revert it back
> to a streaming secondary.

What kind of tests? If this is read-only activity you could simply cut
the network connection between the master and the slave, or restart
the slave after updating recovery.conf such as it is still a standby
but has no primary_conninfo so as it is performing archive recovery,
or at least a fake one.

> Is this possible while not touching the Master DB ? If so what are the
> correct steps pls ?

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.
Regards,
--
Michael


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: create index on a field of udt
Next
From: "Charles Clavadetscher"
Date:
Subject: Re: create index on a field of udt