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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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