From rogerio.pereira@riosoft.com.br Mon Nov  18 18:28:08 2013
Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50793=pgsql-performance-ar@postgresql.org>)
 id 1ViTYO-0008FY-GR
 for pgsql-performance@arkaria.postgresql.org; Mon, 18 Nov 2013 18:28:08 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50793=pgsql-performance-ar@postgresql.org>)
 id 1ViTYN-00006x-W9
 for pgsql-performance@arkaria.postgresql.org; Mon, 18 Nov 2013 18:28:08 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <rogerio.pereira@riosoft.com.br>) id 1ViTYM-00006p-Nw
 for pgsql-performance@postgresql.org; Mon, 18 Nov 2013 18:28:06 +0000
Received: from riosoftweb1.riosoft.com.br ([186.237.128.40]
 helo=emailserver.riosoft.com.br)
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <rogerio.pereira@riosoft.com.br>) id 1ViTYH-0003ZG-AL
 for pgsql-performance@postgresql.org; Mon, 18 Nov 2013 18:28:06 +0000
Received: from [171.171.0.172] ([201.91.189.254]) by riosoft.com.br with
 MailEnable ESMTP; Mon, 18 Nov 2013 16:27:57 -0200
Message-ID: <528A5C2D.4040107@riosoft.com.br>
Date: Mon, 18 Nov 2013 16:27:57 -0200
From: Rogerio Pereira <rogerio.pereira@riosoft.com.br>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:24.0) Gecko/20100101 Thunderbird/24.1.0
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Error Broken pipe in log postgres
Content-Type: multipart/alternative;
 boundary="------------010501030004060203040603"
X-Pg-Spam-Score: -0.6 (/)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

This is a multi-part message in MIME format.
--------------010501030004060203040603
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi,

Which can be the error :

-- could not send data to client: Broken pipe
-- FATAL:  connection to client lost
-- 

Regards,

Assinatura de E-mail padrão Riosoft 20 anos

*Rogerio Pereira *
Dba | Tel. 55 (17) 3215-9199 | rogerio.pereira@riosoft.com.br
Riosoft - Sistemas para Gestão Empresarial <http://www.riosoft.com.br>


Respeite o meio-ambiente, não desperdice papel, imprima somente o 
necessário.
Esta mensagem, incluindo os seus anexos, contém informações 
confidenciais destinadas a indivíduo e propósito específicos e é 
protegida por lei. Caso você não seja o destinatário desta mensagem, 
deve apagá-la. É proibida a utilização, acesso, cópia ou divulgação não 
autorizada das informações presentes neste e-mail. As informações 
contidas nesta mensagem e em seus anexos são de responsabilidade de seu 
autor, não representando idéias, opiniões, pensamentos da Riosoft.


--------------010501030004060203040603
Content-Type: multipart/related;
 boundary="------------060900020900090706040805"


--------------060900020900090706040805
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    Hi,<br>
    <br>
    <div id="gt-src-tools">
      <div id="gt-src-tools-l">
        <div style="display: inline-block;" id="gt-input-tool">
          <div id="itamenu"><span class="ita-kd-inputtools-div"></span></div>
        </div>
      </div>
    </div>
    <div id="gt-res-content" class="almost_half_cell">
      <div dir="ltr" style="zoom:1">
        <div id="tts_button" style="" class=""><object
            type="application/x-shockwave-flash"
            data="//ssl.gstatic.com/translate/sound_player2.swf"
            id="tts" width="18" height="18"></object></div>
        <span id="result_box" class="short_text" lang="en"><span
            class="hps">Which can be</span> <span class="hps">the error
            :<br>
          </span></span></div>
    </div>
    <br>
    -- could not send data to client: Broken pipe<br>
    -- FATAL:&nbsp; connection to client lost<br>
    <div class="moz-signature">-- <br>
      <br>
      Regards,<br>
      <br>
      <meta http-equiv="Content-Type" content="text/html;
        charset=ISO-8859-1">
      <meta name="author" content="Rafael F. Borges - Marketing Riosoft">
      <meta name="language" content="pt-br">
      <title>Assinatura de E-mail padr&atilde;o Riosoft 20 anos</title>
      <table width="100%" cellpadding="0" cellspacing="0" border="0">
        <tbody>
          <tr>
            <td style="font-family:Tahoma; font-size:13px;
              color:#000000">&nbsp;</td>
          </tr>
          <tr>
            <td style="font-family:Tahoma; font-size:13px;
              color:#000000"><font style="font-size:13px"
                color="#000000" face="Tahoma"><span id="_AthCaret"></span></font><br>
            </td>
          </tr>
          <tr>
            <td style="font-family:Tahoma; font-size:13px;
              color:#000000">&nbsp;</td>
          </tr>
          <tr>
            <td>
              <table width="100%" cellpadding="0" cellspacing="0"
                border="0">
                <tbody>
                  <tr>
                    <td><font style="font-size:20px" color="#000000"
                        face="Tahoma"><b>Rogerio Pereira </b></font></td>
                  </tr>
                  <tr>
                    <td height="20"><font style="font-size:11px"
                        color="#000000" face="Tahoma">Dba | Tel. 55 (17)
                        3215-9199 | <a class="moz-txt-link-abbreviated" href="mailto:rogerio.pereira@riosoft.com.br">rogerio.pereira@riosoft.com.br</a></font></td>
                  </tr>
                  <tr>
                    <td><a href="http://www.riosoft.com.br"
                        target="_blank"><img
                          src="cid:part1.04030906.04080001@riosoft.com.br"
                          alt="Riosoft - Sistemas para Gest&atilde;o
                          Empresarial" width="522" border="0"
                          height="56"></a></td>
                  </tr>
                  <tr>
                    <td height="10"><br>
                    </td>
                  </tr>
                  <tr>
                    <td bgcolor="#0057a6" height="20"><br>
                    </td>
                  </tr>
                  <tr>
                    <td height="25"><font style="font-size:12px"
                        color="#777777" face="Tahoma">Respeite o
                        meio-ambiente, n&atilde;o desperdice papel, imprima
                        somente o necess&aacute;rio.</font></td>
                  </tr>
                  <tr>
                    <td><font style="font-size:10px" color="#777777"
                        face="Tahoma">Esta mensagem, incluindo os seus
                        anexos, cont&eacute;m informa&ccedil;&otilde;es confidenciais
                        destinadas a indiv&iacute;duo e prop&oacute;sito espec&iacute;ficos e
                        &eacute; protegida por lei. Caso voc&ecirc; n&atilde;o seja o
                        destinat&aacute;rio desta mensagem, deve apag&aacute;-la. &Eacute;
                        proibida a utiliza&ccedil;&atilde;o, acesso, c&oacute;pia ou
                        divulga&ccedil;&atilde;o n&atilde;o autorizada das informa&ccedil;&otilde;es
                        presentes neste e-mail. As informa&ccedil;&otilde;es contidas
                        nesta mensagem e em seus anexos s&atilde;o de
                        responsabilidade de seu autor, n&atilde;o representando
                        id&eacute;ias, opini&otilde;es, pensamentos da Riosoft.</font></td>
                  </tr>
                </tbody>
              </table>
            </td>
          </tr>
        </tbody>
      </table>
    </div>
  </body>
</html>

--------------060900020900090706040805
Content-Type: image/jpeg;
 name="imgAssinaPadrao.jpg"
Content-Transfer-Encoding: base64
Content-ID: <part1.04030906.04080001@riosoft.com.br>
Content-Disposition: inline;
 filename="imgAssinaPadrao.jpg"

/9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAA8AAD/4QMpaHR0
cDovL25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1
TTBNcENlaGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5z
Om1ldGEvIiB4OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjAtYzA2MCA2MS4xMzQ3NzcsIDIw
MTAvMDIvMTItMTc6MzI6MDAgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDov
L3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRp
b24gcmRmOmFib3V0PSIiIHhtbG5zOnhtcD0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4w
LyIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5z
OnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYj
IiB4bXA6Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDUzUgV2luZG93cyIgeG1wTU06
SW5zdGFuY2VJRD0ieG1wLmlpZDpCOTMyNzM3NzIzMzcxMUUwQjY1NUYwRjA2MEJEMjVENSIg
eG1wTU06RG9jdW1lbnRJRD0ieG1wLmRpZDpCOTMyNzM3ODIzMzcxMUUwQjY1NUYwRjA2MEJE
MjVENSI+IDx4bXBNTTpEZXJpdmVkRnJvbSBzdFJlZjppbnN0YW5jZUlEPSJ4bXAuaWlkOkI5
MzI3Mzc1MjMzNzExRTBCNjU1RjBGMDYwQkQyNUQ1IiBzdFJlZjpkb2N1bWVudElEPSJ4bXAu
ZGlkOkI5MzI3Mzc2MjMzNzExRTBCNjU1RjBGMDYwQkQyNUQ1Ii8+IDwvcmRmOkRlc2NyaXB0
aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+/+4ADkFk
b2JlAGTAAAAAAf/bAIQABgQEBAUEBgUFBgkGBQYJCwgGBggLDAoKCwoKDBAMDAwMDAwQDA4P
EA8ODBMTFBQTExwbGxscHx8fHx8fHx8fHwEHBwcNDA0YEBAYGhURFRofHx8fHx8fHx8fHx8f
Hx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f/8AAEQgAOAIKAwERAAIRAQMR
Af/EAKcAAQABBQEBAAAAAAAAAAAAAAAFAQIDBAYHCAEBAAIDAQAAAAAAAAAAAAAAAAMEAQIF
BhAAAQMDAgQDBAcGBAcAAAAAAgEDBAARBRIGITETB0EiFFFhcTKBkUJSIxUIoWI1dbUWcjMk
NLHR4ZKiY5MRAQACAQIEAgUKBgMBAAAAAAABAgMRBCExEgVBMmFxkYKy8FGBobHB0SITBkJS
YnIjFeEUJKL/2gAMAwEAAhEDEQA/APqmgUCgUCgUCgUCgUCgUCgxuuNtNk44SA2CKpmSoiIi
c1VVrMRqTOjG3NhuGINvtmZipgIkKqopzVEReXGsTWY8GItDYoyjs7lPyyI3J6XV1yokXTq0
29XKajar2X5Orqt48q3x06509Ez7ImfuR5b9Ma+mI9sxCRHlWkJCgUCgUCgUCgUCgUCgUCgU
CgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUHj3fvf+f2weJjYOUsR+Qj
rr5IIlqAdIinmRfG9dftW0pl6pvGujk9z3N8fTFZ0cqxlf1DPwW5zMpXWHW0dbRPTalEk1J5
bc7eFWZ/6UW6Zj7UEf8AcmNYn7Ez2p71Z3J7ib25uYQJ+QpNx5Qh0zR0EVem4KeXjZePDjUW
/wC20rTrx8kmx397X6L821uHKd4R7guMwicY256tsQREYVPTppQ143PjxWo8cbWMPHz6enm3
yTuZy8PJr6OT2RXQBrqOkjYoiKSktkT6VrkRDrTKjMhh4VJpwXBTxBUJP2UmJjmxExPJloyw
tyorpKDbwGacxEkVfqRaTWYYi0SzUZYDlxGz6bjwCf3CJEX6lWnTMsTaGejLxrvT3XzWAyUf
bu3VRvIOgLkmTpQzHqLZttsVumpeaqtdjtuwrkrN7+VyN/vLUtFKc0TAyvd3a0J/c24sh67H
MMEqwHCUkV5ywNISiCIliL7JVJaNtmtGPHXSZnm1idxhib3nWNOTtO3W8ct3A2zkXpzDUI0c
6UZWUIg8qIVy1qt/NzSqe8wV2+SIidVra57Z8czMaJLbG1chjpjZvqINtErmkCI1Jwh0Gqko
N2FR5D5uPjUObPFoS4cE1l2tVVpAb3/g0f8AmmI/qkap9v5vdt8MoNz5fer8UJ9OVQJygUCg
UCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUHy9+o
vIpJ7gNxVVVbgxWgVPeaq4X7CSvUdopph1+eXmu631y6fNDqI36kMJAw7MKHhpBux2kba6jg
C3cUsl7altVOezXm2s2ha/21YjSKy5btbtvOZzfA7rmsFHhg+5ON5RURMzVS/DRfspqverPc
NxSmL9Ks625IdjgvfL+raNI5sfbPKP5Lum9lpEk1iMHKnuqRKoIHm42VbcEKt9/SKbeKxHGd
IabG02zzaZ4RrK6Tmdzd2t6FBbkuRMOCkTUcFXS2yi2RVFLITh8Of/CsTTHs8Wumt/v/AAZi
193l010r9zHunC7i7Tbjx8nF5Fw2pIq6IkvlNGyRDbdBF0ki3Ss7fLXd0mL14w03GK20vE1n
m6/vjv8AzDm2sB+VOOQ8fnI6yZLjaqhLwH8FTTwTVxtzqr2va167dXGazp/ytdx3NuivTwi0
auT2t2+azmDj5TaWeINyR9JTIZuK24K38xCg+eyeC8b1Zz7y2O81y0/x+CDBtK5KROO35/F3
vcPuHuraOyMdjJT4HuqaJg5OAdOlkOCuiK/bW6De3O61Q2W1x5ss2iP8ceC5u9zfDjisz+ef
Fxu3+zGb3Jtw9wy8k6mRkAT8dHFUrpbUOsyXVcvdyq3l7nXHk6K1/LHBWx9utkx9drfmlKdm
d353Nw8rsebPcQ34jv5dMJVN1hbaDBFVUVUsVx48K07lgpjmuWI8eMfO27fnveLYpnw4S87X
a8yb3CXbnr3JEgZKxlnlcj/C5lxJV8un210Z3EVwfqaacOSjGCbZ+jXx5p/udsHNbSxMVybm
pE5uY90hjOEWnyDq1WUyThw8KrbDdxmtMRWK6LG+2k4qxrabauv7L9ucu2mH3QGRdSISk4UB
Lo35kULr5rLwW/y1T7lvYmbY+n6Vrt+zmIrk6voe+Vw3aaUrIsR5kaMSp1JJKgJ48EvVLLvI
pmpi/ivr9ERHP28ElcetZt8yN3t/Bo/80xH9UjV1Nv5vdt8Mqm58vvV+KE+nKoE6GyuZlM5S
Pi4TLRypDRvoch1Wm9LZCKiOkXCM/PyS1k40Fn9xhHN5vJCEZ5gGNTTJOSTVyQTgiAiDQkd+
ncbJdfYlBYW8MYmTahrrBt2OslJBtuiIoJ6FQ0IE0W8VK1vGgzhuvAkw+8UlWm4wgbvVadaL
QZaQMRMRIwJeCEN0oLWt24J2QjAvmLpOoxpNh8NLp/KB6gHRrumjVbV4cKC9N0YTW8DjxsKy
2bplIZeYFW2l85AToAhoN0+S9Bt4/KRJ7ROR+pYF0kjrTrJItr/K6IFy91BpNbswTrottyCJ
TVxALovIBk0iqYAehBIx0r5RVS91AHdeCVh+Qcgo7cbpddJDT0chR8tDZKLoAeky4IVrUFU3
VhFNoOq6iPEINvlHfRnUZaRFXVBG0VV8FKgy5jLHBWMywx6mbNd6MRjVoRVQVMiM7FpERG6q
ifRQYhzMmE2RZtluMuoQjrGJySrykirpBsWxcU0QflQVoKf3XglRkgfNzrIRIjTLzhCInoJX
AACVux+VdaJagj394dUZgQm1GRDlFGNHGJTyEIj8wiw2RKpHYbeCXLjyUNyNunHpj40mW8Kv
SVd0Mxm33V/CNRJNCB1fw+RqQJZeaJyoNjKZ1iJt2Rmo6DLYZjlJaQS0o4KDqSxWK31UGBjP
k1GflZRYceMwrY9SJJOXxdPQKEPRZ03JURLXoL4+7MFIeBht8+qbqsaSZeDS7ZVRtxTAUbJU
4ohWv4UFobw28aKaSlRlG3HUdVp0WyFkVJzQ4oIBqAiqqgqqpagqW7tvo0jySVcbXUV2mnXb
AFtTio2JKjfm+dfL76DMO4sQctYjTxOuJbUbbTptIpAjiIrwAraEoKhImq9BiTdWD6TzpyDj
hHETe9Qy8wqAZaENEdAFIVJbakulBa3urGuOPECq7HaBohNlt910uqbgW6INKVrs8FS9/dwV
Qq1uNiTOxzMP8SPNGRrcJDAwKPpuJAaCQrdeKEl6DckTjby0OEgooSW3zU15irWi1v8A6UCZ
mcbDV5JL6NenZ9S9qvwaVVHV/wByUFEzeKWakJJArKXk2iL9zq87W+TjQYR3LgzbYdGUJNyQ
Bxg0QlRRccFkVuicLuGg0GYc1iyc6YyBI/UrDsl1/wBQgK4TfLnoS9Br5LcmKgvOxXHw9a01
1vTlrTyqhKKqoiVhuHErLagLufDtm008/odcFsj0g4bbavIigjjiBoDVfhrtQVTc+EUn09Qq
BGRxXXibdFq7S6XEB1R6ZkK8LCqreg0crvSBHg9aJqdkFIajI080+2TZOrwNxtQ6iDpuo+Xz
ckoNnb+5GcqUlnQTcmI4rTqIDiASgg3ISMR+0VkTnQZj3JhgkuxyfVFY1o8703OgKtDrMSe0
q0hCKXVNV6DGG68CUd6QUlWm4/T6nVadaJEeLQ2SAYCZCZcBJEstAjbswUh9thp8+qbnQ0Ey
8Gl3mjZqQJoJU+VCtdOKUFMvuFrG5WBEeAiZmMyHFJsHHXNTCtWEG2hMlv1V8KDI3ufAuvxm
G5gm/LbByO2KEqkDhKAla3DzCqLfl40EqPJKCtAoFAoFAoFAoPlaWibk77ujbqtLkiFRLiih
F4Knw/Dr1E/4tn7v2vNR/k3fvfY9C7+7MxreywycGOLTsGQCuqCIl23Lgt7fvKNc7tGaYy9M
zzhf7phj9LWI5S1+2+6gb7I5h9VFJeIZkR9XjYxuzdfidq33e3/9cR4WmJa7bP8A+Wf6YmHG
9kNvycpE3UbA3fcxzkWOvtN0C4fWg1c7pmitsev82qp27HNq30/l0Xfp+zWIw265zGXfCE68
zoaN9UbFHGyXUCqVkRfj7Kd3xWvSs1jXQ7XlrS8xbhqs717mj7y3pBxmCVJjcMPTNOt8Rced
K56V8RGyJf41nt2GcGKbX4a8WN/ljNlitOOnB20vcnbpYUDtxuZh5tyK22ys54EbZac6dwcB
zVqRCv8ANa30Vz6YM/HPjnnx0Xr5cPDDeOXDV5VvvbjWx9yRiwWZGTqH1EZ+O4ius2KyIRAv
1e2uxtM056T110+9y91hjDeOi2v3J7vO5mMpiNo7hnNKJS8ejUlbWRJArqLh4a0LVaoO2dFb
XpXwt9SbuPVatLz41enMd0No4vtcxKYmsuS0hIwzBEk6yyNGjSQJ5ksvFV9lcqNjktn0mOGv
P0OlO9x1w6xPHTk8+/TzhpP57M3E8KhDiMuCjq8EIlTUdv8ACicfjXQ7xljSMcc5lR7VinWc
k8ohpdlGjzPdN3JuJfT15ZL7DdP/AJEtSd0nowRX1R7EfbY68829cp/9UEp1clg4nFGhZedv
4KREI/sQag7JX8tpTd4txrD1HtfmNvSdrY6BipzMl2LFb67LZIphw0+ceYrdPGuTvMV63mbR
prMuptMlJpEVnXSIdTNmsQ45PvlYE5J4qvgiVyt5u8e2xzkyTpWPlpC9ixWvbphxm3nH9w7n
cyp/7KCqhHVOIq4nAlH3D8vx1Vyuy4smW1t1ljS2Tyx/LTw9rbcWrrFK+Wn128fZy9qe3t/B
o/8ANMR/VI1en2/m923wypbny+9X4oT6cqgToTcMGTM0tLjIWUiKK3blkoEDn3h/DdS3wsqe
FBCxdn5GK051gayCqzDbAVkPMuAUYnyVQeEVMVHriIFe9kXlQJO1c/JiizJebkOSYEnHy3ic
NSbF9zW2QqoXe0D5V1adX0rQXJtWc9EkNlEjxpZA02MhZkiTrRt8HS4OD+GC9PgnHjw99Buy
ttznpU10TaQZOTgzm0VSujUQWENC8q+ZeiVrcOXGgjI2z8x1WnZrUeW60zKZkuPyXnFlk+iI
OpCbXpBw5De1/rCf27BycQJKTFUWnHEKLGV9ySrIIKIqdVxBJbldbeHKg5mJiNxZPARojSNY
9qM7LfjzNZq91bvi1+H0xRuxOatWpeXvoM47NybiyT6TEVHwx6I0Uh6SSrEmeodJxxwEXzBw
T30GxmdsZifkJDi9N1s5MWRGfdfdHoNMm2ZtCwIECkpNkupV46qCazuOmSThTISh67Huq620
6qi24JgrZtkQoWngV0Ky2VOVBzj+z8m9MXIqy01peBwMakp+yj03G3F6wiJAS9S6IiW4e+gz
v7Yygxw/LobOPmkhWmNTZBGyRnqJTuH+oS3HSXDV9dBfMwGfV6SDItnAenLOcbGQ5HN4DZQO
iZNtqoaXEQ7oq6kS3jQW4nbWcw7rUyO3FffT1gOROqYti3JkddtQdVpSuNtJXH/qG89tqWuy
X8CDrZSnozrauLcWuo7qJfAi0opLbhQWy8RlZuNdjFBgwHFfiPCUd4nEJI8kHi13js28oLp5
0FT25OJ6SetuzuXZyQcSujLbTQKK2T57tL7vfQQEbb+czm04UA2mIrDDElWHDcMjN11h6O2J
hoTQCdZSJUVV4JagmcvtiW9kWZzTIzBSIER2MUl6LbpkRCSE0i6r61RUJKDGm28szIaDGNs4
psQEXH2JLzgGIx+kIFHIEDUKoNnL6rDf3UGkOy8w5rJwWWTOK0w6ZSXpBuONyG3jcIjBNKEj
a2RKCRze3cvIycuZFcFWZHokdii84wbrcbr9RtXQG4oqvAqW52str0DB7YnwZkR9xGGwZenO
ky0ZmiJLUVARIxFV06bKtqCUmgS7kxZIKqIsS0JUTgl1Z50GDN7ecyWWx8oSEY7KG3ObW93G
9YPNIlvY6yl+PJV9tBEf2TkEwyRfUt/mHq+qkq5X9OjPo+drqfpefhqoNldmv6M42LrYtTWk
axSJqux5jfufwkO3S32USgrC2pNi5SNOF5o0bjm48BKXmyJoQq6nD5DF00X6OHOgzFg8q+WX
ekkwkjKY1iJZsjUBfbB5HPmG/T1PJa/1UGk9tfMpDn4troHEy3SWRKIzRxlRZaYd0hos5wZu
35ksq+ygpN2tmJLsgI6N4+IpE8rISHHmX3hfB9slZIEFm6guvQnFS8edBsO7fzM7JJlJQsRn
utCRGAdNwUahuOOKSnoC5GrqoiW5eNBtRoOehvZMIrcchlyklR3nXD5H0xcAwELoqCBWVC52
oNR3b2ZLGT8EIsehlnKdbnE4XUH1Bm8Im1o8yi4elV18R9/CgpkcBncq8cqUMeM8IxWmmgcN
wVRmYEl01NWwXijdgG31UGwe3JyuyDQ2tL2YZyQ3Uroy000Cj8vzXaWyezxoKzIO5CykDJix
EfdiBMZNkXXGkUH3GlaISVs/MgtedOCey9BTbW25mKnnIfcbNHIotmgKvB4pMiS7a6J5E9Qi
J8KDpUoFAoFAoFAoFAoODwnaHbOG3J+fQhNJWszubhn/AJi3L5l5rVvLvsmSnRM/lVMWyx0t
1RHF1eewkDOYiTisgHUiSg0Oiiqi87pZU5WVKr4sk0tFq84WMmOL1ms8pcfiuz22cfhcphm+
p6DLC2klvqucSaLUCot+HHn7atX7hltaLTprXlwVq7LHWs1jlb0pfZGwMPtBqS1jUVG5JIZ6
iIl1IluZKvsqLcbm+aYm3glwbamKNKobd/ZTaO4px5AmlizHV1PGyuhDL7ypZUv9FTYO45cU
aROselDm2GLJOsxpPoZtodoNs7af9THa6sm1us4qmdvYhL8qfBK03G+yZeFp4N8Gzx4uNY4t
7evbLbG7dDuRj6ZjQ6QlNqoHpTkKqnNK12+8yYvLPBnNtMeXzQ5rDfp/2lj5YSTEpKtrqBHi
UxRU/csIr9NWMvdM140109SDH23DWddNfW73LbYwuWwxYifGF+ESJ5CTkSciRfBfelUseW1L
dVZ0ldyY63jS0aw85H9Oe0Al9VCdNm90ZJwtPw4Jq/8AKuhPd82mnD2KEdqw668XoUHauHh4
RzDsMo1CeZKOYteSzZioqgqnFOC86505bTbqmdbL36VYr0xGkIXZfa7AbSnPS8YJCb4aD1ER
8EW6W1KvtqfcbzJmiItPJFg2mPFMzWObf3psLAbvhtR8qzqNglKO+KqJhq+ZEJPBbVrt91fD
OtZbZ9tTLGloQW1Nlbd7fFKejOmbksURWlNTMtN9Nkslk4rXO73+4aYqxOaePhWOcpe39s0m
eiOfOZRkzJ5TeGTKBAIhiNkoSpTfyNp9ppkvtOr9ovs/HhXltpss3cMsbjcx04o8lPx+XH1L
ufcVpE4sM8f4rfdHp+z1vR8NiouKgNQ4wI202KCgjwTgluFeyU61iI0hH73/AINH/mmI/qka
p9v5vdt8Modz5fer8UJ9OVQJygUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgU
CgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCg57eG4XMDBjTUDqNFJBp8fFQNC5L4Le1qq7
rLOOnVHHTn6lnaYa5L9EzpM8vW2IO68DNaRxqUI3S6g55ST4otV/9vttON4r6+DfLsM1J0mq
6RubDMp/uEcX7raKS1U3H7j2WOPP1f28WKbHLbw0cvuDuTHhN21jF18G0L8R81XwbbG6qtcP
J+4N1u56NpjmP6p+WkfWnvgwbeNc1vo+XGUFAwe5d1PdSWjuNxRrdxsitLeT/wBhov4Ir91P
N8Kv9t/bkUt+ruJ/Uy+nlH4qefe5M0dNY/Tx/wD1P4fa9LwuDx+IhtxYbQtNtigigpZERPBE
r1SCtYrGkckjRlAb3/g0f+aYj+qRqn2/m923wyg3Pl96vxQn05VAnKBQKBQKBQKBQKBQKBQK
BQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKCOzmEg
ZvFP4yeCnGkDpKyqhIqLcSEk4oQql0WtZjWNJYtGrzB/trvrGv6cXko8uMnyFKaXqW/eJvn9
VcTd/t7b5+eseqU/+x3kRpFq2j+qOP1NmJ263pMRByeY6Df2ghNCyqovNOofUJPoRKjwftjZ
4516er+6dUd91urxpbJp/bGn1uo2/wBt8Bh3OuLPVll/mSXFJx0v8TpqpfQlkru48VaRpWIi
EFMNazrzt888ZdY2222CA2KCKckTglSJV9AoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAo
FAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoP/9k=
--------------060900020900090706040805--

--------------010501030004060203040603--





From cjames@emolecules.com Mon Nov  18 19:49:07 2013
Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50794=pgsql-performance-ar@postgresql.org>)
 id 1ViUol-00031a-Ow
 for pgsql-performance@arkaria.postgresql.org; Mon, 18 Nov 2013 19:49:07 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50794=pgsql-performance-ar@postgresql.org>)
 id 1ViUol-00059n-7M
 for pgsql-performance@arkaria.postgresql.org; Mon, 18 Nov 2013 19:49:07 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <cjames@emolecules.com>) id 1ViUoj-00056z-74
 for pgsql-performance@postgresql.org; Mon, 18 Nov 2013 19:49:05 +0000
Received: from mail-qe0-f44.google.com ([209.85.128.44])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <cjames@emolecules.com>) id 1ViUof-0001mf-LF
 for pgsql-performance@postgresql.org; Mon, 18 Nov 2013 19:49:04 +0000
Received: by mail-qe0-f44.google.com with SMTP id ne12so3640307qeb.17
 for <pgsql-performance@postgresql.org>; Mon, 18 Nov 2013 11:49:00 -0800 (PST)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20130820;
 h=x-gm-message-state:mime-version:in-reply-to:references:date
 :message-id:subject:from:to:content-type;
 bh=AJQbLTQC0Uv3cVWskiAB/vpgGaz6JotZA1Mbn87IonI=;
 b=ePITwLstiYnnbvYVFeLyxEgwZJ+C18ZkgCsG5yQlQES29xwV5pCetcXdUGoLixQo62
 YeJLLk2M6LlMSZ64HeJEm++XgyJ3gH6Vl7s55xlDEf4yH6vUHdTjFCnIhPeDcQdt1BSA
 p6+8o7dvEDP8I7b6+zLv7bEuT70Nxhv5+cUIBldocwOL5AMVdLRgRVEeFbZF4cThOhgq
 zd5/vLMCl7DONo6WFXGKbLThCPosiR3I9YbWqekcD5kZZFKuD3xBpeViYaB7kj7l5zLg
 LIbvvBFaqsG8Ti4nlhjFcploivm0f2bkdgnHk0/vylwGxHTq7KS3ab/0ShmkqI/YQyPC
 u9AA==
X-Gm-Message-State: 
 ALoCoQnqVhqosEeIBEQU2MiWy10UbBpEIk9AqJNlsWyem036LfiVHb4J/7OyeNx6hdp93fj/IFQ9
MIME-Version: 1.0
X-Received: by 10.224.67.200 with SMTP id s8mr36583224qai.75.1384804140425;
 Mon, 18 Nov 2013 11:49:00 -0800 (PST)
Received: by 10.96.109.227 with HTTP; Mon, 18 Nov 2013 11:49:00 -0800 (PST)
In-Reply-To: <528A5C2D.4040107@riosoft.com.br>
References: <528A5C2D.4040107@riosoft.com.br>
Date: Mon, 18 Nov 2013 11:49:00 -0800
Message-ID: 
 <CAFwQ8rdE3g5yu7Zv77TUXexaKwhc_+SG90hC3GQC3CYZmDYcqQ@mail.gmail.com>
Subject: Re: Error Broken pipe in log postgres
From: Craig James <cjames@emolecules.com>
To: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Content-Type: multipart/alternative; boundary=001a11c3218adfb99404eb78d6c9
X-Pg-Spam-Score: -0.7 (/)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

--001a11c3218adfb99404eb78d6c9
Content-Type: text/plain; charset=ISO-8859-1

2013/11/18 Rogerio Pereira <rogerio.pereira@riosoft.com.br>

> Which can be the error :
>
> -- could not send data to client: Broken pipe
> -- FATAL:  connection to client lost
>

It means the client program disconnected from the Postgres server (or was
killed) before the server finished a query, and the server had no place to
send the answer.

Craig

--001a11c3218adfb99404eb78d6c9
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra"><div class=3D"gmail_quote">2013=
/11/18 Rogerio Pereira <span dir=3D"ltr">&lt;<a href=3D"mailto:rogerio.pere=
ira@riosoft.com.br" target=3D"_blank">rogerio.pereira@riosoft.com.br</a>&gt=
;</span><br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
 =20

   =20
 =20
  <div text=3D"#000000" bgcolor=3D"#FFFFFF"><span lang=3D"en"><span>Which c=
an be</span> <span>the error
            :<br>
          </span></span><div>
    </div>
    <br>
    -- could not send data to client: Broken pipe<br>
    -- FATAL:=A0 connection to client lost<br></div></blockquote><div><br><=
/div><div>It means the client program disconnected from the Postgres server=
 (or was killed) before the server finished a query, and the server had no =
place to send the answer.<br>
<br>Craig <br></div></div><br></div></div>

--001a11c3218adfb99404eb78d6c9--