Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 8EBEC16FA505 for ; Mon, 9 Jul 2012 20:40:41 -0300 (ADT) Received: from mail-pb0-f46.google.com ([209.85.160.46]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SoNZH-0002Z1-M8 for pgsql-admin@postgresql.org; Mon, 09 Jul 2012 23:40:41 +0000 Received: by pbbrp8 with SMTP id rp8so19984420pbb.19 for ; Mon, 09 Jul 2012 16:40:25 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:x-gm-message-state; bh=u/qReKVGkGvXtSO7lTtXT7HIZGeKP5sz0SoQI1GACBI=; b=oianlakwrQpIGZoka2wctdSTnwNZJGOXNpVX265LcK6KZI14G4cBS/0CbKxWl4/GAq mqqPOHr5oFptC7deqhwx81hOSWQW06Yb9GwXb88uDEqT2dNuyCxUf70uV1LHScNFqHKg bUHvRo8amy84bOHzAdF1ULD78H6tFbfb8+Y8jQSEBIYdhbS4ppxdyPAmCypzXIcui45H Nbrao6aTN7BlQ3r1601ers5BHWw/d4bdlHWgYOokT3rh0wcwjTTOF5LV1zs31rya0TVg Ya8reI2/v/pXmc34cMjTh6hh4W7Tofc1quJFPVOsNnsWFyi3jnDBJwfhibI9nYxQ63H+ ASZQ== Received: by 10.68.203.66 with SMTP id ko2mr64848390pbc.84.1341877225367; Mon, 09 Jul 2012 16:40:25 -0700 (PDT) Received: from ayaki.localdomain (124-169-169-118.dyn.iinet.net.au. [124.169.169.118]) by mx.google.com with ESMTPS id gh9sm16058070pbc.20.2012.07.09.16.40.22 (version=SSLv3 cipher=OTHER); Mon, 09 Jul 2012 16:40:24 -0700 (PDT) Message-ID: <4FFB6BE4.1080101@ringerc.id.au> Date: Tue, 10 Jul 2012 07:40:20 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:13.0) Gecko/20120605 Thunderbird/13.0 MIME-Version: 1.0 To: =?ISO-8859-1?Q?Eduardo_S=E1_dos_Reis?= CC: pgsql-admin@postgresql.org Subject: Re: Error: could not send data to client: Connection reset by peer References: <67A07D932F8DCC41989A050EDE427A210CF9B5@JETWINSRVRPS02.onmobile.com> <67399E6B82A54062AEE2B9159FB96F86@P01148515> In-Reply-To: <67399E6B82A54062AEE2B9159FB96F86@P01148515> Content-Type: multipart/alternative; boundary="------------020200040606000208080405" X-Gm-Message-State: ALoCoQn9JINSLQH8NaoSr5tseM3MMngg24eRyEj8ZIF6IIDvnTB49wBiXsarbu76z0cOa2SqGzPx X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201207/28 X-Sequence-Number: 39745 This is a multi-part message in MIME format. --------------020200040606000208080405 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit On 07/09/2012 09:26 PM, Eduardo Sá dos Reis wrote: > Hi, > In my Postgres log the message is occurring: > 1 4ffad9f4.67db 2012-07-09 10:17:40 BRT LOG: connection received: > host=10.20.0.1 port=2368 > 2 4ffad9f4.67db 2012-07-09 10:17:40 BRT LOG: connection authorized: > user=usu_cad database=prd_cad > 3 4ffad9f4.67db 2012-07-09 10:17:42 BRT LOG: *could not send data to > client: Connection reset by peer* > 4 4ffad9f4.67db 2012-07-09 10:17:42 BRT LOG: *unexpected EOF on client > connection* > Users can not run the system. If this is a Windows system with a 3rd party software firewall (Windows Firewall is OK, anything else isn't) then remove or disable the firewall and see if the problem goes away. Otherwise, more info please. PostgreSQL version, OS and version, client program, whether the client program is using psqlODBC, pgJDBC, libpq directly, etc. -- Craig Ringer --------------020200040606000208080405 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
On 07/09/2012 09:26 PM, Eduardo Sá dos Reis wrote:
Hi,
 
In my Postgres log the message is occurring:
 
1 4ffad9f4.67db 2012-07-09 10:17:40 BRT LOG:  connection received: host=10.20.0.1 port=2368
2 4ffad9f4.67db 2012-07-09 10:17:40 BRT LOG:  connection authorized: user=usu_cad database=prd_cad
3 4ffad9f4.67db 2012-07-09 10:17:42 BRT LOG:  could not send data to client: Connection reset by peer
4 4ffad9f4.67db 2012-07-09 10:17:42 BRT LOG:  unexpected EOF on client connection
 
Users can not run the system.

If this is a Windows system with a 3rd party software firewall (Windows Firewall is OK, anything else isn't) then remove or disable the firewall and see if the problem goes away.

Otherwise, more info please. PostgreSQL version, OS and version, client program, whether the client program is using psqlODBC, pgJDBC, libpq directly, etc.

--
Craig Ringer
--------------020200040606000208080405--