Dead Postmasters

От
Len Morgan
Тема
Dead Postmasters
Дата
Msg-id
002501bfac6b$bb498920$0908a8c0@H233.bstx.cc
Список
Дерево обсуждения
Re: how do I set DateStyle = European in postmaster ? "Anthony E. Greene" <agreene@pobox.com>
On a couple of my installations, I've noticed that after a few days there
are several "dead" postmasters (i.e., not associated with any running
backend).  When I do a ps -ax (RedHat 6.1, Postgresql 6.5.3) I see:

...
[postmaster]
[postmaster]
[postmaster]
[postmaster]
[postmaster]
[postmaster]
...
and several

/usr/bin/postgres ..... lines

The problem is that there are more [postmaster] lines (sometimes 4 or 5
times as many) as there are /usr/bin/postgres lines.

When I do a kill -TERM pid on all of the [postmaster] pids or restart the
postmaster, the system gets much faster.  The problem is I also cut of
"live" connections in the process.  My question is: Is there any way I can
determine which of the [postmaster] entries are associated with which
/usr/bin/postgres entries?

Thank you!

Len Morgan

В списке pgsql-admin по дате отправления
От: Sly Golovanov
Дата:
Сообщение: windows nt
От: Teddy Turmeaux
Дата:
Поиск
Список
Период
Сортировка
Искать
FAQ