From: Jeroen T. Vermeulen <jtv@xs4all.nl>
To: Kashyap Jani <kjani@cognitronics.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Dropped conection from libpq PGconn
Date: Thu, 15 Dec 2005 09:13:02 +0700 (ICT)
Message-ID: <21828.202.47.247.130.1134612782.squirrel@webmail.xs4all.nl> (raw)
In-Reply-To: <43A0A212.2070202@cognitronics.com>
References: <43A0A212.2070202@cognitronics.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jtv@xs4all.nl, kjani@cognitronics.com
Subject: Re: Dropped conection from libpq PGconn
In-Reply-To: <21828.202.47.247.130.1134612782.squirrel@webmail.xs4all.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox