Re: Synchronous commit behavior during network outage

Поиск
Список
Период
Сортировка
От Andrey Borodin
Тема Re: Synchronous commit behavior during network outage
Дата
Msg-id 54B6E300-382E-4C40-9CC7-F8DD32C0075A@yandex-team.ru
обсуждение исходный текст
Ответ на Synchronous commit behavior during network outage  (Ondřej Žižka <ondrej.zizka@stratox.cz>)
Ответы Re: Synchronous commit behavior during network outage
Список pgsql-hackers
Hi Ondrej!

> 19 апр. 2021 г., в 22:19, Ondřej Žižka <ondrej.zizka@stratox.cz> написал(а):
>
> Do you think, that would be possible to implement a process that would solve this use case?
> Thank you
> Ondrej
>

Feel free to review patch fixing this at [0]. It's classified as "Server Features", but I'm sure it's a bug fix.

Yandex.Cloud PG runs with this patch for more than half a year. Because we cannot afford loosing data in HA clusters.

It's somewhat incomplete solution, because PG restart or crash recovery will make waiting transactions visible. But we
protectfrom this on HA tool's side. 

Best regards, Andrey Borodin.

[0] https://commitfest.postgresql.org/33/2402/


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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: problem with RETURNING and update row movement
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: Replication slot stats misgivings