Postgres Pro
Downloads
Home   >   mailing lists

Re: Psql or test application hangs when interface is down for the DB server - Mailing list pgsql-bugs

From Gregory Stark
Subject Re: Psql or test application hangs when interface is down for the DB server
Date
Msg-id 87prpemahr.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Psql or test application hangs when interface is down for the DB server  ("K, Niranjan (NSN - IN/Bangalore)" <niranjan.k@nsn.com>)
Responses Re: Psql or test application hangs when interface is down for the DB server  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
"K, Niranjan (NSN - IN/Bangalore)" <niranjan.k@nsn.com> writes:

> Is there any other workaround or alternative so that the situation about
> the interface is down is known and based on that the 'PQexec' does not
> get blocked for ~15 minutes.

Absent threads I think you have to use alarm() and a SIGALRM signal handler.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's Slony Replication support!

pgsql-bugs by date:

Previous
From: "Dave Page"
Date:
Subject: Re: BUG #4303: insufficient privileges
Next
From: Tom Lane
Date:
Subject: Re: Psql or test application hangs when interface is down for the DB server