Re: outdated (bad) information in pg_stat_activity

From: hubert depesz lubaczewski <depesz(at)gmail(dot)com>
To: Chris Browne <cbbrowne(at)acm(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: outdated (bad) information in pg_stat_activity
Date: 2005-12-15 10:05:57
Message-ID: 9e4684ce0512150205h69bddc1fj98baadb4e8b5f939@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/14/05, Chris Browne <cbbrowne(at)acm(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Brünink 2005-12-15 10:08:45 copying a database without dumping it
Previous Message Guido Neitzer 2005-12-15 09:24:28 Re: Improving Availability