Re: outdated (bad) information in pg_stat_activity - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: outdated (bad) information in pg_stat_activity
Date
Msg-id 9e4684ce0512150205h69bddc1fj98baadb4e8b5f939@mail.gmail.com
Whole thread Raw
In response to Re: outdated (bad) information in pg_stat_activity  (Chris Browne <cbbrowne@acm.org>)
Responses Re: outdated (bad) information in pg_stat_activity
List pgsql-general
On 12/14/05, Chris Browne <cbbrowne@acm.org> wrote:
The only answer I have been able to come to is that restarting the
postmaster will clear this all up.

this is actually not an option for me.
of course i can make myself a function which will check if pid exists, but it would generally be better if there was some way to fix the problem in postgresql itself.
a series of delete's from some specific place perhaps?

depesz

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Timestamp <-> ctime conversion question ...
Next
From: Tom Lane
Date:
Subject: Re: outdated (bad) information in pg_stat_activity