Date: Wed, 11 Oct 2006 18:33:13 +0300
From: Dmitriy Chumack <saint@apriorit.com>
Reply-To: Dmitriy Chumack <saint@apriorit.com>
Organization: Apriorit
Message-ID: <95520488.20061011183313@apriorit.com>
To: pgsql-interfaces@postgresql.org
Subject: libpq - check PGconn* - is it valid
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi everyone.

I have such a problem. My application, some server, use libpq librarry
to interact with PostgreSQL-8.1.0 database. Postgresql server and my
server work on different computers in the local network. When my server
starts, it creates pool of 10 connections to database. My server use
PQexec() to submit queries to db. But when there is no network
connection to the database (I simply unplug the network cable from
computer on which PG server is run) and my server calls PQexec() -
than it hangs in PQexec() call. And it will hang there for a very
long time (I wait about 30 minutes and there is no result). And
when I plug in the network cable back, PQexec() remains hanging (I
wait about 10 minutes and there is no result too).

I use simply (not ssl) connection to db.

So how can I check PGconn pointer if it represent a health connection
to prevent my server to hang in PQexec() call?

Thanks in advance.
-- 
Best regards,
 Dmitriy Chumack                         mailto:saint@apriorit.com
Software Developer of ApriorIT