clear defunct entries from pg_stat_activity

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: clear defunct entries from pg_stat_activity
Date: 2004-02-27 23:20:17
Message-ID: 1077924017.2784.51.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

http://archives.postgresql.org/pgsql-general/2003-11/msg00581.php

In the above Jan Wieck mentions a bug that occurs in pg 7.3.4 that
causes a crashing backend to hang around in the stats until the slot is
reused, due to the message that tells that the backend terminates is
never sent to the collector daemon.

I'm curious if anyone knows if this was fixed in 7.4, and perhaps more
importantly if there is a way to clear these entries in 7.3.4. (I was
thinking perhaps some entries in the stats tables but didn't find
anything...)

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shane Wegner 2004-02-28 00:00:09 Re: efficient storing of urls
Previous Message Mike Nolan 2004-02-27 23:19:49 Restoring a table with a different name