Re: Turn off streaming replication - leaving Master running

Поиск

Список

Период

Сортировка

От	Andy Erskine
Тема	Re: Turn off streaming replication - leaving Master running
Дата	30 июня 2015 г. 07:40:36
Msg-id	CADqp7UAJnO-6CNQ=z4S-P_TBkNGtbN+Ga_GZbEC4YwR7ge8PXA@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Turn off streaming replication - leaving Master running (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы	Re: Turn off streaming replication - leaving Master running (Michael Paquier <michael.paquier@gmail.com>)
Список	pgsql-general

Дерево обсуждения

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.vondra@2ndquadrant.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general