Re: [GENERAL] psql hanging

2007-09-13 Thread Steve Crawford
Trevor Talbot wrote: > Unless psql is turning on keepalive or similar, or the OS is forcing > it on by default, there are no timeouts for idle TCP connections. If > the command was transported to the server successfully and psql was > just waiting for a result, the connection is idle and nothing

Re: [GENERAL] psql hanging

2007-09-05 Thread Trevor Talbot
On 9/5/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: > On Wed, Sep 05, 2007 at 10:44:20AM -0700, Trevor Talbot wrote: > > Unless psql is turning on keepalive or similar, or the OS is forcing > > it on by default, there are no timeouts for idle TCP connections. If > > the command was transp

Re: [GENERAL] psql hanging

2007-09-05 Thread Scott Marlowe
On 9/5/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: > On Wed, Sep 05, 2007 at 10:44:20AM -0700, Trevor Talbot wrote: > > Unless psql is turning on keepalive or similar, or the OS is forcing > > it on by default, there are no timeouts for idle TCP connections. If > > the command was transp

Re: [GENERAL] psql hanging

2007-09-05 Thread Martijn van Oosterhout
On Wed, Sep 05, 2007 at 10:44:20AM -0700, Trevor Talbot wrote: > Unless psql is turning on keepalive or similar, or the OS is forcing > it on by default, there are no timeouts for idle TCP connections. If > the command was transported to the server successfully and psql was > just waiting for a re

Re: [GENERAL] psql hanging

2007-09-05 Thread Trevor Talbot
On 9/5/07, Richard Huxton <[EMAIL PROTECTED]> wrote: > Steve Crawford wrote: > > 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

Re: [GENERAL] psql hanging

2007-09-05 Thread Steve Crawford
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 -c "insert into..." >> >> A while back

Re: [GENERAL] psql hanging

2007-09-05 Thread Richard Huxton
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 -c "insert into..." A while back I had to restart the server and today dis