Re: Turn off streaming replication - leaving Master running

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Turn off streaming replication - leaving Master running
Дата
Msg-id CAB7nPqTUeRy42YLPee0wcioAqUqPr8yF02Sc+7sC=CKiwmxqTg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Turn off streaming replication - leaving Master running  (Andy Erskine <andy.erskine@jds.net.au>)
Ответы Re: Turn off streaming replication - leaving Master running  (Andy Erskine <andy.erskine@jds.net.au>)
Список pgsql-general
Дерево обсуждения


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

В списке pgsql-general по дате отправления:

Предыдущее
От: Andy Erskine
Дата:
Сообщение: Re: Turn off streaming replication - leaving Master running
Следующее
От: Andy Erskine
Дата:
Сообщение: Re: Turn off streaming replication - leaving Master running