Re: psql query gets stuck indefinitely - Mailing list pgsql-general

From Tomas Vondra
Subject Re: psql query gets stuck indefinitely
Date
Msg-id 3c2577902e90f233d79b7b5664629961.squirrel@sq.gransy.com
Whole thread Raw
In response to Re: psql query gets stuck indefinitely  (tamanna madaan <tamanna.madaan@globallogic.com>)
Responses Re: psql query gets stuck indefinitely
List 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 by date:

Previous
From: "Tomas Vondra"
Date:
Subject: Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
Next
From: Magnus Hagander
Date:
Subject: Re: How to restore the table space tar files created by pg_basebackup?