Re: transaction timeout

Поиск
Список
Период
Сортировка
От Dr NoName
Тема Re: transaction timeout
Дата
Msg-id 20050726162451.70502.qmail@web31501.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Re: transaction timeout  (Scott Marlowe <smarlowe@g2switchworks.com>)
Ответы Re: transaction timeout  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: transaction timeout  ("Frank L. Parks" <fparks@ezbizpartner.com>)
Список pgsql-general
> The common view on this kind of thing is that if
> your client is broken,
> you need to fix it.

The problem is, we can't fix the users, nor can we fix
other software that our client has to interact with.
There will always be occasional situations when a
client gets stuck.

> That said, I have seen some folks post about writing
> a perl or shell
> script that runs every x minutes looking for
> connections that have been
> idle for > a certain amount of time and kill the
> backend associated with
> it (sigterm, not -9...)

what are the implications of killing a postmaster
process?

thanks,

Eugene

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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

Предыдущее
От: Dr NoName
Дата:
Сообщение: Re: transaction timeout
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: transaction timeout