Disconnected Backends

Поиск
Список
Период
Сортировка
От Glen and Rosanne Eustace
Тема Disconnected Backends
Дата
Msg-id 007801c0721f$6f463a80$0101a8c0@godzone.net.nz
обсуждение исходный текст
Ответы Re: Disconnected Backends  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I have recently allowed one of my clients to use ipsql as a means to manage
one of his databases on my server.  The server is currently running 6.5.1
and will be upgraded to 7.0 on 1/1 so if this is version specific the
problem may go away.

It would seem that the postmaster either doesn't shut down a remote
connection properly or is not able to detect when the remote client has gone
away.  I get lots of postmasters for what I know to be old connections still
hanging about.  This is a bit of a worry as they consume resources and keep
databases open that could easily be closed.

Any comments would be appreciated.
--
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand
Ph: +64 6 357 8168, Mobile: +64 21 424 015


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: MD5 use in PL/Perl
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Disconnected Backends