Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0E75B6502A1 for ; Tue, 22 Jul 2008 12:52:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 14995-01-2 for ; Tue, 22 Jul 2008 12:51:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp100.biz.mail.re2.yahoo.com (smtp100.biz.mail.re2.yahoo.com [206.190.52.46]) by postgresql.org (Postfix) with SMTP id C51D965039C for ; Tue, 22 Jul 2008 12:47:28 -0300 (ADT) Received: (qmail 11637 invoked from network); 22 Jul 2008 15:47:26 -0000 Received: from unknown (HELO STSBANWRK134) (sunil@6dtech.co.in@61.95.192.235 with login) by smtp100.biz.mail.re2.yahoo.com with SMTP; 22 Jul 2008 15:47:25 -0000 X-YMail-OSG: JNBM97sVM1kFVHzTNRtl9IF1ygkUsLOkU9mdU_H5DmrjzF53fDLr_SrwcbP5QERiS7eaVAt7d3Q4E46FtZtblmNvj8zmKuJpWoKftg_GsQ-- X-Yahoo-Newman-Property: ymail-3 Message-ID: <001901c8ec12$66ad2990$be00a8c0@6dBangalore.co.in> From: "Sunil Khatri" To: Subject: PQstatus is getting blocked when database sytem powered off Date: Tue, 22 Jul 2008 21:18:32 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0016_01C8EC40.7EBF56B0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200807/14 X-Sequence-Number: 6772 This is a multi-part message in MIME format. ------=_NextPart_000_0016_01C8EC40.7EBF56B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, In my application I need to check connection status before executing the = query. I am doing it using PQstatus.=20 Problem is : PQstatus is getting blocked If the system on which database = server is running is powered off. If I shutdown the database using pg_ctl stop or pkill -9 postmaster in = that case its returning. Is there any other way to check the connection status in this case? Thanks=20 Sk ------=_NextPart_000_0016_01C8EC40.7EBF56B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

In my application I need to check = connection status=20 before executing the query. I am doing it using PQstatus.

Problem is : PQstatus is getting = blocked If the=20 system on which database server is running is powered off.

If I shutdown the database using pg_ctl = stop or=20 pkill -9 postmaster in that case its returning.

Is there any other way to check the = connection=20 status in this case?

Thanks

------=_NextPart_000_0016_01C8EC40.7EBF56B0--