Re: psql hanging

Steve Crawford wrote:
> 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".

The OS should clear that connection down after a timeout - hours
perhaps, but months doesn't sound right. When the connection gets closed
down psql should exit.

What OS is this? Someone here should be able to figure out what's going on.

--
Richard Huxton
Archonet Ltd