Re: Turn off streaming replication - leaving Master running

No i don't want a replica.

I would like to reconfigure my streaming scenario into two standalone db's
i don't want the Master to be effected in anyway and i want it running
consistantly .. the secondary i want to reconfigure as a standalone to load
a different db and do some testing.

When i've finished testing - i want to reconfigure for streaming again.

On 30 June 2015 at 12:37, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> wrote:

> Hi,
>
> On 06/29/2015 09:27 AM, Andy Erskine wrote:
>
>> Thanks Jeff,
>>
>> I don't want a clone - i want to temporaily turn off replication
>> (and therefore failover) and load a different db into the secondary
>> which is now writable and run some tests. Then i will remove this db
>> and run a basebackup to reinstate a copy of the master and turn on
>> replication again.
>>
>
> So you want replica and you don't want replica at the same time?
>
> Is there any reason why you simply don't want to either create a new
> snapshot using pg_basebackup, or just simply shut down the standby, create
> a copy of the data directory, remove the recovery conf and start it again
> as a standalone database?
>
> regards
>
> --
> Tomas Vondra http://www.2ndQuadrant.com
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)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(dot)erskine(at)jds(dot)net(dot)au <andy(dot)erskine(at)jds(dot)net(dot)au>*

*W*: www.jds.net.au
Level 8, 2 Russell Street, Melbourne, VIC 3000
GPO Box 4777, Melbourne VIC 3001

[image: JDS Signature v1]