Message-ID: <21828.202.47.247.130.1134612782.squirrel@webmail.xs4all.nl>
In-Reply-To: <43A0A212.2070202@cognitronics.com>
References: <43A0A212.2070202@cognitronics.com>
Date: Thu, 15 Dec 2005 09:13:02 +0700 (ICT)
Subject: Re: Dropped conection from libpq PGconn
From: "Jeroen T. Vermeulen" <jtv@xs4all.nl>
To: "Kashyap Jani" <kjani@cognitronics.com>
Cc: pgsql-interfaces@postgresql.org
User-Agent: SquirrelMail/1.4.5
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit

On Thu, December 15, 2005 05:52, Kashyap Jani wrote:

>     I was wondering why does PGconn object keeps saying the connection
> is OK if I lost my Ethernet connection to the box where my database is
> running ?
> If that's the case does any one know how to check if my connection
> objects are not valid anymore without using PGReset function call.

First of all, the change in status will probably only be noticed if you
actually try to use the connection and it fails.  This in turn may take a
very long time to time out if the physical connection is not there; you
may try looking for system-specific settings that can make your OS give up
on the connection more easily, but by nature it has to keep retrying for
as long as it can.

Finally, there used to be a bug in libpq where, even though PGresults
would come back with error codes when the connection broke with certain
errors (including connection timeout), it would fail to mark a connection
error in the PGconn.  This was fixed just a few months ago; the libpq in
8.1 should have the patch IIRC.

Here is some discussion on that:

http://svr5.postgresql.org/pgsql-interfaces/2005-07/msg00003.php


Jeroen