Re: psql hanging

Richard Huxton wrote:
> 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.
>

RedHat 7.3 w/kernel update to 2.4.18-5 (grrrr - specific requirement to
support hardware/drivers we have).

Cheers,
Steve