Re: killing idle postgres instances

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: killing idle postgres instances
Дата
Msg-id 20040206124903.GA22232@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Re: killing idle postgres instances  ("Marcus Andree S. Magalhaes" <marcus.magalhaes@vlinfo.com.br>)
Список pgsql-jdbc
On Thu, Feb 05, 2004 at 08:56:15PM -0200, Marcus Andree S. Magalhaes wrote:
>
> Thanks, Tom,
>
> but the connections are closed by a finally clause.

If you have idle connections, then necissarily, that's not happening.

> And, besides, when the vm exits, all tcp/ip connections should be closed...

I've definitely seen cases where this is not the case; they're
closed, but not properly.  Eventually PostgreSQL will notice that the
client is gone and shut the connection down, but that will take some
time (like 2 hours).

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The plural of anecdote is not data.
        --Roger Brinner

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

Предыдущее
От: Jan Oksfeldt Jonasen
Дата:
Сообщение: ResultSet construction and byte arrays
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: ResultSet construction and byte arrays