Re: pg_stat_replication log positions vs base backups

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: pg_stat_replication log positions vs base backups
Дата
Msg-id CAB7nPqThVVEGr5HHKhwoT2_Tg89AxfVKACinOUwCvKHcebzzeg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_stat_replication log positions vs base backups  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: pg_stat_replication log positions vs base backups  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-hackers
On Mon, Dec 14, 2015 at 8:59 AM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> On Mon, Dec 14, 2015 at 1:01 AM, Magnus Hagander <magnus@hagander.net> wrote:
>> I've applied these two patches now.
>>
>> The one that fixes the initialization backpatched to 9.3 which is the oldest
>> one that has it, and the one that changes the actual 0-vs-NULL output to 9.5
>> only as it's a behaviour change.
>
> Thanks!

Interesting. I got just today a bug report that is actually a symptom
that people should be careful about: it is possible that
pg_stat_replication reports 1/potential for sync_priority/sync_state
in the case of a WAL sender in "backup" state: a base backup just
needs to reuse the shared memory slot of a standby that was previously
connected. Commit 61c7bee of Magnus fixes the issue, just let's be
careful if there are similar reports that do not include this fix.
-- 
Michael



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: pgbench stats per script & other stuff
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: A typo in syncrep.c