By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,760 Members | 1,173 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,760 IT Pros & Developers. It's quick & easy.

clear defunct entries from pg_stat_activity

P: n/a
http://archives.postgresql.org/pgsql...1/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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.