Re: kill -KILL: What happens? - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: kill -KILL: What happens?
Date
Msg-id 4D3023DD0200002500039587@gw.wicourts.gov
Whole thread Raw
In response to Re: kill -KILL: What happens?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: kill -KILL: What happens?  (Florian Pflug <fgp@phlo.org>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> wrote:
> If postmaster dies, and then another backend crashes, then your
> backend running "your honking big query" could run across
> corrupted state and then you'd be in serious trouble.
Worst of all, it could give bogus results without error.  I really
don't see a production use case for letting backends continue after
postmaster failure -- unless you only kinda, sorta care whether
committed data is actually retrievable or reported data is actually
accurate.
-Kevin


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Error code for "terminating connection due to conflict with recovery"
Next
From: Stefan Kaltenbrunner
Date:
Subject: Maintenance downtime for commitfest.postgresql.org and media.postgresql.org