Re: Turn off streaming replication - leaving Master running - Mailing list pgsql-general
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@hogranch.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@postgresql.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.erskine@jds.net.au
W: www.jds.net.au
Level 8, 2 Russell Street, Melbourne, VIC 3000
GPO Box 4777, Melbourne VIC 3001
Attachment
pgsql-general by date: