How to solve the problem of one backend process crashing and causing other processes to restart?

Поиск
Список
Период
Сортировка
От yuansong
Тема How to solve the problem of one backend process crashing and causing other processes to restart?
Дата
Msg-id 37b7a067.1773.18bc68459d2.Coremail.yyuansong@126.com
обсуждение исходный текст
Ответы Re: How to solve the problem of one backend process crashing and causing other processes to restart?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

In PostgreSQL, when a backend process crashes, it can cause other backend processes to also require a restart, primarily to ensure data consistency. I understand that the correct approach is to analyze and identify the cause of the crash and resolve it. However, it is also important to be able to handle a backend process crash without affecting the operation of other processes, thus minimizing the scope of negative impact and improving availability. To achieve this goal, could we mimic the Oracle process by introducing a "pmon" process dedicated to rolling back crashed process transactions and performing resource cleanup? I wonder if anyone has attempted such a strategy or if there have been previous discussions on this topic.

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

Предыдущее
От: "Zhijie Hou (Fujitsu)"
Дата:
Сообщение: RE: Synchronizing slots from primary to standby
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: [EXTERNAL] Re: Add non-blocking version of PQcancel