Re: Turn off streaming replication - leaving Master running

Поиск
Список
Период
Сортировка
От Andy Erskine
Тема Re: Turn off streaming replication - leaving Master running
Дата
Msg-id CADqp7UApEHxvH4u7EPup+wMWK9N4JONhutSo_-+sqnWx2iBo9g@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  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Дерево обсуждения
If i touch my trigger file and promote my secondary to a master - what effect will that have on the Master - will i need to make any changes on that side ? Will it still try and stream data across to the promoted secondary and just fill up the log files with error messages ?

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


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



--

Andy Erskine

 

JDS Australia
P 1300 780 432 | M 0431919301 | F 03 90124578

E: andy.erskine@jds.net.au

W: www.jds.net.au
Level 8, 2 Russell Street, Melbourne, VIC 3000
GPO Box 4777, Melbourne VIC 3001

JDS Signature v1

Вложения

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

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