Re: PQstatus is getting blocked when database sytem powered off

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Sunil Khatri" <sunil(at)6dtech(dot)co(dot)in>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: PQstatus is getting blocked when database sytem powered off
Date: 2008-07-22 17:28:46
Message-ID: 714.1216747726@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

"Sunil Khatri" <sunil(at)6dtech(dot)co(dot)in> writes:
> Problem is : PQstatus is getting blocked If the system on which database server is running is powered off.

Hardly likely, considering that PQstatus is just

ConnStatusType
PQstatus(const PGconn *conn)
{
if (!conn)
return CONNECTION_BAD;
return conn->status;
}

I have no doubt that a query-issuing call could get blocked if the
postmaster stops responding, but not PQstatus.

regards, tom lane

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Sunil Khatri 2008-07-23 06:48:18 Re: PQstatus is getting blocked when database sytem powered off
Previous Message Sunil Khatri 2008-07-22 15:48:32 PQstatus is getting blocked when database sytem powered off