Re: Turn off streaming replication - leaving Master running

Поиск

Список

Период

Сортировка

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

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

Ok so a question i should have asked at the very beginning ..

If i touch my trigger file - promoting the secondary to a master - will that in anyway effect the master thats already running ?

IE no files on the master will change ?

Then all i'll have to do is shutdown the secondary when i've finished and run the basebackup process again to restore replication (and change recovery.done - conf again.

thanks.

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

On Tue, Jun 30, 2015 at 1:39 PM, Andy Erskine <andy.erskine@jds.net.au> wrote:
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.

Well, in this case:
1) promote your standby
2) Run your tests on it.
3) Recreate a new standby
The documentation online, as well as the PostgreSQL wiki have all the documentation to help you achieve those steps.
Regards,
--
Michael