Re: Do we need to handle orphaned prepared transactions in theserver?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Do we need to handle orphaned prepared transactions in theserver?
Дата
Msg-id 20200422180629.GN19613@momjian.us
обсуждение исходный текст
Ответ на Re: Do we need to handle orphaned prepared transactions in the server?  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Wed, Apr 22, 2020 at 01:05:17PM -0400, Robert Haas wrote:
> On Tue, Apr 21, 2020 at 6:10 PM Bruce Momjian <bruce@momjian.us> wrote:
> > I thought if something was wrong, they might look at the server logs
> > after a restart, or they might have a higher probability of having
> > orphaned prepared transactions after a restart.
> 
> Maybe slightly, but having a monitoring tool like check_postgres.pl
> for this sort of thing still seems like a vastly better solution.

It is --- I was just thinking we should have a minimal native warning.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: 2pc leaks fds
Следующее
От: Andres Freund
Дата:
Сообщение: Re: design for parallel backup