Re: Troublesome handling of dropped connection - Mailing list pgsql-general

From Tom Lane
Subject Re: Troublesome handling of dropped connection
Date
Msg-id 19020.1006875004@sss.pgh.pa.us
Whole thread Raw
In response to Re: Troublesome handling of dropped connection  (Francisco Reyes <lists@natserv.com>)
Responses Re: Troublesome handling of dropped connection  (Francisco Reyes <lists@natserv.com>)
List pgsql-general
Francisco Reyes <lists@natserv.com> writes:
>> Did you look to see whether your old session had disconnected or not?

> How would I see this from within psql?

Right now I think "ps" on the server machine is the only viable way.
In 7.2 the pg_stat_activity table would give you a clue, at least.
You might care to read
http://candle.pha.pa.us/main/writings/pgsql/sgml/monitoring.html
which is from 7.2 docs, but the info about using ps applies to 7.1.

            regards, tom lane

pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Troublesome handling of dropped connection
Next
From: Francisco Reyes
Date:
Subject: Re: Timing a query