Re: psql query gets stuck indefinitely

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: psql query gets stuck indefinitely
Дата
Msg-id 3c2577902e90f233d79b7b5664629961.squirrel@sq.gransy.com
обсуждение исходный текст
Ответ на Re: psql query gets stuck indefinitely  (tamanna madaan <tamanna.madaan@globallogic.com>)
Ответы Re: psql query gets stuck indefinitely
Список pgsql-general
On 1 Prosinec 2011, 12:57, tamanna madaan wrote:
> Hi Craig
> I am able to reproduce the issue now . I have postgres-8.1.2 installed in
> cluster setup.

Well, the first thing you should do is to upgrade, at least to the last
8.1 minor version, which is 8.1.22. It may very well be an already fixed
bug (haven't checked). BTW the 8.1 branch is not supported for a long
time, so upgrade to a more recent version if possible.

Second - what OS are you using, what version? The keep-alive needs support
at OS level, and if the OS is upgraded as frequently as the database (i.e.
not at all), this might be already fixed.

And finally - what do you mean by 'cluster setup'?

Tomas


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

Предыдущее
От: "Tomas Vondra"
Дата:
Сообщение: Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: How to restore the table space tar files created by pg_basebackup?