Fwd: Disable Streaming Replication without restarting either master or slave

Поиск
Список
Период
Сортировка
От Michael Nolan
Тема Fwd: Disable Streaming Replication without restarting either master or slave
Дата
Msg-id CAOzAqu+zk69AuKnPWmQmeU3U6m1t86JdcmAU83c88YgJuNxqfw@mail.gmail.com
обсуждение исходный текст
Ответ на Disable Streaming Replication without restarting either master or slave  (Samba <saasira@gmail.com>)
Ответы Re: Disable Streaming Replication without restarting either master or slave  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-general
Дерево обсуждения


---------- Forwarded message ----------
From: Michael Nolan <htfoot@gmail.com>
Date: Tue, May 29, 2012 at 1:37 PM
Subject: Re: [GENERAL] Disable Streaming Replication without restarting either master or slave
To: Fujii Masao <masao.fujii@gmail.com>




On Tue, May 29, 2012 at 1:15 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
On Tue, May 29, 2012 at 10:17 PM, François Beausoleil
<francois@teksol.info> wrote:
 
> Are per-chance looking for pg_xlog_replay_pause() and
> pg_xlog_replay_resume() ?

Those can pause and resume WAL replay in the standby, but not streaming
replication. Even while WAL replay is being paused, WAL can be streamed
from the master to the standby.

Regards,

--
Fujii Masao

So, that means that the only ways to stop streaming replication are to stop the slave server, to disable access to the master via the pg_hba.conf file (requiring the master configs be reloaded) or to set the trigger file on the slave to tell it to stop replicating the master. 

And if the master/slave are set to synchronous streaming replication, your options are more limited, since the master has to know to stop waiting for the synchronous slave to respond. 

Once the slave has gone out of asynchronous replication mode, wuld it be possible to resume asynchronous replication by stopping the slave server, removing the trigger file, and restarting it in asynchronous streaming replication mode?  This would, at a minimum, depend on how many updates have occurred on the master during the time streaming replication was disabled and having all the WAL files available, right?
--
Mike Nolan

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

Предыдущее
От: Sergey Konoplev
Дата:
Сообщение: Re: Disable Streaming Replication without restarting either master or slave
Следующее
От: "David Johnston"
Дата:
Сообщение: Interval Division Workaround Suggestions (sub-day intervals only)?