Postgres Pro
Downloads
Home   >   mailing lists

PQstatus is getting blocked when database sytem powered off - Mailing list pgsql-interfaces

From Sunil Khatri
Subject PQstatus is getting blocked when database sytem powered off
Date
Msg-id 001901c8ec12$66ad2990$be00a8c0@6dBangalore.co.in
Whole thread Raw
Responses Re: PQstatus is getting blocked when database sytem powered off  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
Tree view
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
 

pgsql-interfaces by date:

Previous
From: "Sunil Khatri"
Date:
Subject: PQstatus is not returning
Next
From: Tom Lane
Date:
Subject: Re: PQstatus is getting blocked when database sytem powered off