Re: [GENERAL] psql query gets stuck indefinitely

2011-12-06 Thread tamanna madaan
Hi All Please help me . Thanks... Tamanna On Mon, Dec 5, 2011 at 12:45 PM, tamanna madaan < tamanna.mad...@globallogic.com> wrote: > Hi Tomas > > I tried it on the system having postgres-8.4.0 . And the behavior is same > . > > Cluster means a group of machines having postgres installed on all

Re: [GENERAL] psql query gets stuck indefinitely

2011-12-04 Thread tamanna madaan
Hi Tomas I tried it on the system having postgres-8.4.0 . And the behavior is same . Cluster means a group of machines having postgres installed on all of them . Same database is created on all the machines one of which working as master DB on which operation (like insert/delete/update) will

Re: [GENERAL] psql query gets stuck indefinitely

2011-12-01 Thread Tomas Vondra
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

Re: [GENERAL] psql query gets stuck indefinitely

2011-12-01 Thread tamanna madaan
Hi Craig I am able to reproduce the issue now . I have postgres-8.1.2 installed in cluster setup. I have started the below query from one system let say A to system B in cluster . psql -U -h -c "select sleep(300);" while this command is going on , system B is stopped abruptly by taking out the po

Re: [GENERAL] psql query gets stuck indefinitely

2011-11-29 Thread tamanna madaan
well, one question : Is tcp-keep-alive enabled by default in postgres-8.1.2 . I am using postgres on linux platform . On Tue, Nov 29, 2011 at 8:51 AM, tamanna madaan < tamanna.mad...@globallogic.com> wrote: > Hi Craig > > Thanks for your reply . But unfortunately I dont have that process runni

Re: [GENERAL] psql query gets stuck indefinitely

2011-11-28 Thread Craig Ringer
On 29/11/11 11:21, tamanna madaan wrote: > Hi Craig > > Thanks for your reply . But unfortunately I dont have that process > running right now. I have already killed that process . But I have > seen this problem sometimes on my setup. > It generally happens when the remote system is going slow for

Re: [GENERAL] psql query gets stuck indefinitely

2011-11-28 Thread tamanna madaan
Hi Craig Thanks for your reply . But unfortunately I dont have that process running right now. I have already killed that process . But I have seen this problem sometimes on my setup. It generally happens when the remote system is going slow for some reason (CPU utilization high etc.) . But whate

Re: [GENERAL] psql query gets stuck indefinitely

2011-11-28 Thread Craig Ringer
On 11/28/2011 05:30 PM, tamanna madaan wrote: Hi All I have postgres installed in cluster setup. My system has a script which executes the below query on remote system in cluster. psql -t -q -Uslon -h -d -c"select 1;" But somehow this query got stuck. It didnt return even after the remote system(

Re: [GENERAL] psql query gets stuck indefinitely

2011-11-28 Thread Craig Ringer
On 11/28/2011 05:30 PM, tamanna madaan wrote: Hi All I have postgres installed in cluster setup. My system has a script which executes the below query on remote system in cluster. psql -t -q -Uslon -h -d -c"select 1;" But somehow this query got stuck. It didnt return even after the remote sy

[GENERAL] psql query gets stuck indefinitely

2011-11-28 Thread tamanna madaan
Hi All I have postgres installed in cluster setup. My system has a script which executes the below query on remote system in cluster. psql -t -q -Uslon -h -d -c"select 1;" But somehow this query got stuck. It didnt return even after the remote system( on which this query was supposed to execute