Re: [HACKERS] keepalive in libpq using

2010-07-08 Thread Fujii Masao
On Thu, Jul 8, 2010 at 5:27 PM, Magnus Hagander wrote: > In this scenario, wouldn't it work if the *ssh connection* had > keepalives enabled though? Then that one should tear down, which in > turn would send a clear signal to libpq the connection is gone. Sorry, I'm not sure that. Can the ssh con

Re: [HACKERS] keepalive in libpq using

2010-07-08 Thread Magnus Hagander
On Thu, Jul 8, 2010 at 10:23, Fujii Masao wrote: > On Thu, Jul 8, 2010 at 4:57 PM, Pavel Golub wrote: >> Sounds good for me. My customer proposed such a scenario: >> >> I have opened connection to database server (ver 8.4.3) through the >> SSH tunnel. This tunnel is created by external program "P

Re: [HACKERS] keepalive in libpq using

2010-07-08 Thread Fujii Masao
On Thu, Jul 8, 2010 at 4:57 PM, Pavel Golub wrote: > Sounds good for me. My customer proposed such a scenario: > > I have opened connection to database server (ver 8.4.3) through the > SSH tunnel. This tunnel is created by external program "PUTTY". My PC running > Application > is connected to th

Re: [HACKERS] keepalive in libpq using

2010-07-08 Thread Pavel Golub
Hello, Fujii. You wrote: FM> On Wed, Jul 7, 2010 at 10:04 PM, Robert Haas wrote: >> On Tue, Jul 6, 2010 at 1:08 PM, Pavel Golub wrote: >>> While I'm very excited about enabling keepalives in libpq, I want to >>> know how can I use this functionality in my application? >>> >>> Let's imagine that

Re: [HACKERS] keepalive in libpq using

2010-07-07 Thread Fujii Masao
On Wed, Jul 7, 2010 at 10:04 PM, Robert Haas wrote: > On Tue, Jul 6, 2010 at 1:08 PM, Pavel Golub wrote: >> While I'm very excited about enabling keepalives in libpq, I want to >> know how can I use this functionality in my application? >> >> Let's imagine that I connect to a server with keepaliv

Re: [HACKERS] keepalive in libpq using

2010-07-07 Thread Robert Haas
On Tue, Jul 6, 2010 at 1:08 PM, Pavel Golub wrote: > While I'm very excited about enabling keepalives in libpq, I want to > know how can I use this functionality in my application? > > Let's imagine that I connect to a server with keepalives option, other > options (keepalives_idle, keepalives_int

[HACKERS] keepalive in libpq using

2010-07-06 Thread Pavel Golub
Hello all. While I'm very excited about enabling keepalives in libpq, I want to know how can I use this functionality in my application? Let's imagine that I connect to a server with keepalives option, other options (keepalives_idle, keepalives_interval, keepalives_count) are used either. Then ne