database still hanging - Mailing list pgsql-general

From alonso
Subject database still hanging
Date
Msg-id 12668226.post@talk.nabble.com
Whole thread Raw
Responses Re: count (*)  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
What would cause psql to hang indefinitely when the backend disappears?

We have a script that uses psql to insert a record (TCP connection to DB
on different machine). The command is basically
psql <connection_stuff> -c "insert into..."

A while back I had to restart the server and today discovered that some
of the client machines have psql processes dating back several months.

Obviously no TCP connection on the server end but client-side shows the
connection as "ESTABLISHED".
--
View this message in context: http://www.nabble.com/database-still-hanging-tf4440057.html#a12668226
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: alonso
Date:
Subject: count (*)
Next
From: Bill Moran
Date:
Subject: Re: constrains on two tables