Hosting Provided By

Re: [GENERAL] (Never?) Kill Postmaster?

From: Tom Lane <tgl(at)sss.pgh.pa.us>
Date: Wed Oct 31 2007 - 19:59:57 EDT

=?ISO-8859-1?Q?Christian_Schr=F6der?= <cs@deriva.de> writes:
> But then, when I tried to reconnect to the database, I received the
> following message:

> <2007-10-31 22:50:01 CET - chschroe> FATAL: the database system is in
> recovery mode

> Ok, you wrote "Postgres will recover automatically", but could this take
> several minutes?

Yeah, potentially. I don't suppose you have any idea how long it'd been since your last checkpoint, but what do you have checkpoint_timeout and checkpoint_segments set to?

> What is the conclusion of this experience?

That you have an itchy trigger finger ;-). It looks from the log that you needed to wait only a few seconds longer for the recovery to have completed.

What I'd like to know about is why the child process was unresponsive to SIGINT in the first place. There's little we can do about long-running plpython functions, for instance, but if it was looping in Postgres proper then we should do something about that. Can you reproduce this problem easily?

regards, tom lane

---------------------------(end of broadcast)---------------------------

TIP 6: explain analyze is your friend Received on Wed Oct 31 20:08:03 2007

Do you need help?

This message: [ Message body ]
Next message: Christian Schröder: "Re: [GENERAL] (Never?) Kill Postmaster?"
Previous message: Joshua D. Drake: "[GENERAL] PostgreSQL Conference Fall 2007 wrap up"
In reply to: Christian Schröder: "Re: [GENERAL] (Never?) Kill Postmaster?"
Next in thread: Christian Schröder: "Re: [GENERAL] (Never?) Kill Postmaster?"
Reply: Christian Schröder: "Re: [GENERAL] (Never?) Kill Postmaster?"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 19:10:52 EDT