Skip site navigation (1) Skip section navigation (2)

Re: phantom backends

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: phantom backends
Date: 2006-02-25 03:42:43
Message-ID: 87wtfkje8c.fsf@wolfe.cbbrowne.com (view raw or flat)
Thread:
Lists: pgsql-general
Oops! pgsql(at)bluepolka(dot)net ("Ed L.") was seen spray-painting on a wall:
> I have a bunch of 7.4.6 backend processes that show up via 
> pg_stat_get_db_numbackends(), pg_stat_get_backend_idset(), etc, 
> but do not show up in ps.  Any clues?

Possibly your statistics collector got "overrun," and the last time it
was successfully updated, they were there?
-- 
(reverse (concatenate 'string "moc.liamg" "@" "enworbbc"))
http://linuxdatabases.info/info/internet.html
If a man speaks in the forest and there is no woman to hear him, is he
still wrong?

In response to

pgsql-general by date

Next:From: Christopher BrowneDate: 2006-02-25 03:46:58
Subject: Re: Requesting LinuxWorld East staffers
Previous:From: Christopher BrowneDate: 2006-02-25 03:41:45
Subject: Re: Backup file extension

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group