Re: [HACKERS] keepalives_* parameters usefullness

2011-07-04 Thread Fujii Masao
On Tue, Jul 5, 2011 at 4:00 AM, Jaime Casanova wrote: > Simon Riggs writes: >> There's a list of preconditions as to when these settings take effect, >> otherwise they are a no-op. >> > > do we know what those preconditions are? The keepalives don't work at least on linux when the connection is

Re: [HACKERS] keepalives_* parameters usefullness

2011-07-04 Thread Jaime Casanova
Simon Riggs writes: > On Mon, Jul 4, 2011 at 9:42 AM, Jaime Casanova wrote: > >> i even used getsockopt() to ensure TCP_KEEPIDLE was being setted and >> tried to set it myself with setsockopt() with the same results. > > There's a list of preconditions as to when these settings take effect, > ot

Re: [HACKERS] keepalives_* parameters usefullness

2011-07-04 Thread Simon Riggs
On Mon, Jul 4, 2011 at 9:42 AM, Jaime Casanova wrote: > i even used getsockopt() to ensure TCP_KEEPIDLE was being setted and > tried to set it myself with setsockopt() with the same results. There's a list of preconditions as to when these settings take effect, otherwise they are a no-op. --  

[HACKERS] keepalives_* parameters usefullness

2011-07-04 Thread Jaime Casanova
Hi, AFAIU TFM if i set keepalives_* parameters in a conninfo they set the internal counters to these values so if i execute: """ conn = PQconnectdb("host=192.168.204.10 keepalives=1 keepalives_idle=45 keepalives_interval=5 keepalives_count=5"); """ that means that the client's connection to t