Re: Turn off streaming replication - leaving Master running

Поиск

Список

Период

Сортировка

От	Andy Erskine
Тема	Re: Turn off streaming replication - leaving Master running
Дата	29 июня 2015 г. 08:58:07
Msg-id	CADqp7UB9nHWhsjeHQw0bhoXBkBy5WXvtSiHCnQ_YKoGXC4bmoA@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Turn off streaming replication - leaving Master running (Michael Paquier <michael.paquier@gmail.com>)
Список	pgsql-general

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

Cheers Micheal,

So i don't want to touch the file as this will promote it too a master - i would just like it as a standalone db for this instance - i need to load a db and do some testing.

After which i will delete the data directory and run the basebackup cmd and pull the db back from the master and set up streaming again.

Just need to be certain of the right steps so i don't effect the Master in any way.

On 29 June 2015 at 15:52, Michael Paquier <michael.paquier@gmail.com> wrote:

On Mon, Jun 29, 2015 at 2:42 PM, Andy Erskine <andy.erskine@jds.net.au> wrote:
> I'd like to turn off the streaming on my postgresdb (9.2) It is currently
> setup to stream from master to a single secondary.
>
> I want to shutdown the secondary and turn it into another master and connect
> it to another application for testing - after which i want to revert it back
> to a streaming secondary.

What kind of tests? If this is read-only activity you could simply cut
the network connection between the master and the slave, or restart
the slave after updating recovery.conf such as it is still a standby
but has no primary_conninfo so as it is performing archive recovery,
or at least a fake one.

> Is this possible while not touching the Master DB ? If so what are the
> correct steps pls ?

Well, yes. It depends on what you want to do then. If this testing
really requires to promote the standby then you will need to take a
new fresh base backup knowing that you are using 9.2.
Regards,
--
Michael