From: Terry Lee Tucker <terry@leetuckert.net>
To: pgsql-interfaces@postgresql.org
Subject: Re: libpq - check PGconn* - is it valid
Date: Wed, 11 Oct 2006 12:11:07 -0400
Message-ID: <200610111211.07614.terry@leetuckert.net> (raw)
In-Reply-To: <95520488.20061011183313@apriorit.com>
References: <95520488.20061011183313@apriorit.com>
On Wednesday 11 October 2006 11:33 am, Dmitriy Chumack <saint@apriorit.com>
thus communicated:
> 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.
Use: ConnStatusType PQstatus(const PGconn *conn);
See the docs for details.
--
Terry Lee Tucker
Turbo's IT Manager
Turbo, division of Ozburn-Hessey Logistics
2251 Jesse Jewell Pkwy NE
Gainesville, GA 30501
Tel: (336) 372-6812 Fax: (336) 372-6812 Cell: (336) 363-4719
terry@turbocorp.com
www.turbocorp.com
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: terry@leetuckert.net
Subject: Re: libpq - check PGconn* - is it valid
In-Reply-To: <200610111211.07614.terry@leetuckert.net>
* 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