Message-ID: <4C52D8F7.6020705@archonet.com>
Date: Fri, 30 Jul 2010 14:51:51 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.1.11) Gecko/20100713 Lightning/1.0b1 Thunderbird/3.0.6
MIME-Version: 1.0
To: Kananda <Kananda@stepsoftware.com.br>
CC: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: Re: PostgreSQL keepalives help
References: <4A704C139DFD804DB74FFB9CC0BE79FC790B5631C3@SBS.step.local>
In-Reply-To: <4A704C139DFD804DB74FFB9CC0BE79FC790B5631C3@SBS.step.local>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 29/07/10 21:16, Kananda wrote:
> I need the records are free for edit, in few minutes. Therefore I set
> the KEEPALIVE configuration in my "postgresql.conf":

> tcp_keepalives_idle = 60 # TCP_KEEPIDLE, in seconds;
> tcp_keepalives_interval = 60 # TCP_KEEPINTVL, in seconds;
> tcp_keepalives_count TCP_KEEPCNT = 5 #;

If this is actually what you have in your file, you have an error in 
your count setting.

Try "show tcp_keepalives_count;" and so on - just check they're set as 
you expect them to be. If they have the right values, put wireshark or 
some other network monitor onto the connection and see if any packets 
are being sent back and fore while there is no real traffic.

Oh, and please don't cross-post to multiple lists (particular 
-cluster-hackers - can't see the relevance of that).

-- 
   Richard Huxton
   Archonet Ltd