Postgres Pro
Downloads
Home   >   mailing lists

Re: Do we need to handle orphaned prepared transactions in the server? - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Do we need to handle orphaned prepared transactions in the server?
Date
Msg-id CA+TgmoYR60M3BhszMJFvM1KRmuUAQTvD325yOEAG22YKMTB9PA@mail.gmail.com
Whole thread Raw
In response to Re: Do we need to handle orphaned prepared transactions in theserver?  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Do we need to handle orphaned prepared transactions in theserver?
List pgsql-hackers
Tree view 
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.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: design for parallel backup
Next
From: Alvaro Herrera
Date:
Subject: Re: More efficient RI checks - take 2