Re: pg_stat_replication.state: streaming/catchup

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: pg_stat_replication.state: streaming/catchup
Дата
Msg-id CAB7nPqT1VO+YyP8Wk_JysBdYKuZOmV9Ydopd83N47y51rHFKKQ@mail.gmail.com
обсуждение исходный текст
Ответ на pg_stat_replication.state: streaming/catchup  (Torsten Förtsch <torsten.foertsch@gmx.net>)
Ответы Re: pg_stat_replication.state: streaming/catchup
Список pgsql-general



On Mon, Apr 21, 2014 at 8:03 PM, Torsten Förtsch <torsten.foertsch@gmx.net> wrote:
Hi,

just out of curiosity, what's the difference between "streaming" and
"catchup" state in pg_stat_replication.

According to the documentation this field is "Current WAL sender state".
But that does not tell me anything.
When a standby connects for the first time to a primary, it is not yet synchronized, this is the "catchup" phase. Once the lag between the standby and the master is reduced to zero for the first time, replication state changes to "streaming".
--
Michael

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

Предыдущее
От: Torsten Förtsch
Дата:
Сообщение: pg_stat_replication.state: streaming/catchup
Следующее
От: Torsten Förtsch
Дата:
Сообщение: Re: pg_stat_replication.state: streaming/catchup