Re: outdated (bad) information in pg_stat_activity

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: outdated (bad) information in pg_stat_activity
Дата
Msg-id 9e4684ce0512150205h69bddc1fj98baadb4e8b5f939@mail.gmail.com
обсуждение исходный текст
Ответ на Re: outdated (bad) information in pg_stat_activity  (Chris Browne <cbbrowne@acm.org>)
Ответы Re: outdated (bad) information in pg_stat_activity  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On 12/14/05, Chris Browne <cbbrowne@acm.org> wrote:
The only answer I have been able to come to is that restarting the
postmaster will clear this all up.

this is actually not an option for me.
of course i can make myself a function which will check if pid exists, but it would generally be better if there was some way to fix the problem in postgresql itself.
a series of delete's from some specific place perhaps?

depesz

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Timestamp <-> ctime conversion question ...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: outdated (bad) information in pg_stat_activity