Re: Turn off streaming replication - leaving Master running

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Turn off streaming replication - leaving Master running
Дата
Msg-id CAB7nPqTsb363OwuXh2H888KZrjUQ6wx8UusgKjXYLM+A0G8-AA@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 Mon, Jun 29, 2015 at 3:34 PM, Andy Erskine <andy.erskine@jds.net.au> wrote:
no snapshot available .. i don't mind running basebackup once i've finished my test.

So if someone could help with the steps to turn off replication and bring secondary up as a standalone db that would be great.

How to promote a node: pg_ctl promote or use a trigger_file:
Turning temporarily off replication has little meaning if you intend to bring back a new standby afterwards.
My 2c.
--
Michael

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: create index on a field of udt
Следующее
От: Andy Erskine
Дата:
Сообщение: Re: Turn off streaming replication - leaving Master running