Re: Turn off streaming replication - leaving Master running

Поиск

Список

Период

Сортировка

От	Andy Erskine
Тема	Re: Turn off streaming replication - leaving Master running
Дата	29 июня 2015 г. 10:28:05
Msg-id	CADqp7UAWbU6P48fsvV6OYj6u9sN_DHcjHT5=hqwOD02ACL898A@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Turn off streaming replication - leaving Master running (John R Pierce <pierce@hogranch.com>)
Ответы	Re: Turn off streaming replication - leaving Master running (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список	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