"Pavel Golub" <[EMAIL PROTECTED]> writes:
> 1. Connect to server.
> 2. Execute some queries, e.g. SELECT 2;
> 3. Wait for a while (to be sure I suggest 20 minutes)
> 4. Try to execute query, e.g. SELECT version()
> We got an error: "server closed the connection unexpectedly. This probably
> means the server terminates abnormaly before or while processing the
> request."
[ shrug... ] You've got broken networking infrastructure. Postgres
itself does not have any connection timeout. (Some have complained
that this is a bug, but at least it lets us reject this type of
complaint as not our problem...)
If you were using 8.1 you might be able to stave off the connection
drop by reducing tcp_keepalives_idle, but I don't have any suggestions
for 8.0.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
