=?ISO-8859-1?Q?Christian_Schr=F6der?= <cs@xxxxxxxxx> 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
