Re: Lost connections

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Lost connections
Дата
Msg-id 20030130145656.N983@mail.libertyrms.com
обсуждение исходный текст
Ответ на Lost connections  ("Donald Fraser" <demolish@cwgsy.net>)
Список pgsql-admin
On Thu, Jan 30, 2003 at 07:10:47PM -0000, Donald Fraser wrote:
> 1) How as an administrator can I tell which connections are lost
> and which are not so I can shut down the appropriate processes?

The dead connection should get cleaned up when the TCP timeout
happens, as I understand it.

> 2) Is there a way of connecting to the server with client
> applications that can avoid this situation. That is can the client
> software do something extra when connecting such as additional
> parameters, keep alive socket options... to avoid this scenario?

Not as far as I know.  You could lower your TCP timeout, I guess, but
I believe the TCP/IP authorities say this is a Bad Idea.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


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

Предыдущее
От: Oliver Vecernik
Дата:
Сообщение: Re: Making connections to postgres under FreeBSD
Следующее
От: Len Conrad
Дата:
Сообщение: Fwd: Postfix SMTP server: errors from relay2.pgsql.com[64.49.215.143]