clear defunct entries from pg_stat_activity - Mailing list pgsql-general

From Robert Treat
Subject clear defunct entries from pg_stat_activity
Date
Msg-id 1077924017.2784.51.camel@camel
Whole thread Raw
Responses Re: clear defunct entries from pg_stat_activity  (Jan Wieck <JanWieck@Yahoo.com>)
List 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


pgsql-general by date:

Previous
From: Mike Nolan
Date:
Subject: Restoring a table with a different name
Next
From: Shane Wegner
Date:
Subject: Re: efficient storing of urls