From: Sunil Khatri <sunil@6dtech.co.in>
To: pgsql-interfaces@postgresql.org
Subject: PQstatus is getting blocked when database sytem powered off
Date: Tue, 22 Jul 2008 21:18:32 +0530
Message-ID: <001901c8ec12$66ad2990$be00a8c0@6dBangalore.co.in> (raw)
Hi,
In my application I need to check connection status before executing the query. I am doing it using PQstatus.
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
Sk
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: sunil@6dtech.co.in
Subject: Re: PQstatus is getting blocked when database sytem powered off
In-Reply-To: <001901c8ec12$66ad2990$be00a8c0@6dBangalore.co.in>
* 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