Basebackups reported as idle

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Basebackups reported as idle
Дата
Msg-id CABUevEwX4g8y=gmgfPzxFKS7gqjSYNR949Xc96OQm=YXJmh_Og@mail.gmail.com
обсуждение исходный текст
Ответы Re: Basebackups reported as idle  (David Steele <david@pgmasters.net>)
Re: Basebackups reported as idle  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
AFAICT, base backups running on the replication protocol are always reported as "idle" in pg_stat_activity. This seems to have been an oversight in the "include walsender backends in pg_stat_activity" in 10, which does include it for walsenders in general, just not for the ones sending base backups. (and was then improved on later with the "include all non-standard backends" patch).

Unlike the regular walsender it also has to set it back to IDLE, since you can actually finish a base backup without disconnecting.

PFA a patch that fixes this. I think this is bugfix-for-backpatch, I don't think it has a large risk of breaking things. Thoughts?

Also, in setting this, there is no real way to differentiate between a regular walsender and a basebackup walsender, other than looking at the wait events. They're both listed as walsenders. Should there be?  (That might not be as easily backpatchable, so keeping that as a separate one)

--
Вложения

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

Предыдущее
От: Beena Emerson
Дата:
Сообщение: Re: [HACKERS] Runtime Partition Pruning
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: [HACKERS] parallel.c oblivion of worker-startup failures