Re: Turn off streaming replication - leaving Master running

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 :

shutdown secondary
change hba_conf so primary cannot connect
rename recovery.conf
start db
load new db
run tests

shutdown db
basebackup db from master
revert streaming settings
startdb

thanks.

On 29 June 2015 at 17:12, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> On 6/29/2015 12:06 AM, Jeff Janes wrote:
>
>> But since you want a clone, what is the point of first setting up
>> streaming, and then breaking it? Just use pg_basebackup to set up a clone
>> directly, without ever having started streaming. It seems like you are
>> just going to confuse yourself about what is a standby meant for fail over,
>> and what is a clone meant for testing. With possibly disastrous
>> consequences.
>>
>
>
> VERY good point!
>
>
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> 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]