<div dir="ltr"><p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif;color:rgb(33,33,33);background-image:initial;background-repeat:initial">Dear I'm trying to run
the following and I get the following error and I can not figure out what the
problem is , I could help ?</span><span lang="EN-US" style="font-family:Arial,sans-serif;background-image:initial;background-repeat:initial"></span></p>
<p class="MsoNormal"><span lang="EN-US"><br>
</span><span lang="EN-US" style="font-family:Arial,sans-serif;color:rgb(33,33,33);background-image:initial;background-repeat:initial">Any information that need be notified
me and sent them</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif;color:rgb(33,33,33);background-image:initial;background-repeat:initial"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:Arial,sans-serif;color:rgb(33,33,33);background-image:initial;background-repeat:initial">Thanks a lots!!!!!</span><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal">-bash-4.2$ psql -h localhost -U postgres -p 5432</p>
<p class="MsoNormal">psql (9.4.4)</p>
<p class="MsoNormal">Digite «help» para obtener ayuda.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span lang="EN-US">postgres=#</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><b><span lang="EN-US">-bash-4.2$
psql -h localhost -U postgres -p 9999</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US">psql:
ERROR: unable to read message length</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US">DETALLE:
message length (12) in slot 1 does not match with slot 0(8)</span></b></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal">Any idea?</p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><u>pg_hba.conf</u></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"># TYPE DATABASE USER
ADDRESS
METHOD</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"># "local" is for Unix domain socket connections
only</p>
<p class="MsoNormal">local all
all
md5</p>
<p class="MsoNormal"># IPv4 local connections:</p>
<p class="MsoNormal">host all
all <a href="http://127.0.0.1/32">127.0.0.1/32</a>
md5</p>
<p class="MsoNormal">host all
all <a href="http://0.0.0.0/0">0.0.0.0/0</a>
md5</p>
<p class="MsoNormal"># IPv6 local connections:</p>
<p class="MsoNormal"># Allow replication connections from localhost, by a user
with the</p>
<p class="MsoNormal"># replication privilege.</p>
<p class="MsoNormal">local replication postgres
trust</p>
<p class="MsoNormal">host replication replication
<a href="http://0.0.0.0/0">0.0.0.0/0</a>
trust</p>
<p class="MsoNormal">#host replication postgres
::1/128
trust</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">-rwxrw-r--. 1 apache apache 33283 abr 1 15:49
pgpool.conf</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><u>pgpool.conf</u></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"># - Authentication -</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">enable_pool_hba = on</p>
<p class="MsoNormal">
# Use
pool_hba.conf for client authentication</p>
<p class="MsoNormal">pool_passwd = 'pool_passwd'</p>
<p class="MsoNormal">
# File
name of pool_passwd for md5 authentication.</p>
<p class="MsoNormal">
#
"" disables pool_passwd.</p>
<p class="MsoNormal">
# (change
requires restart)</p>
<p class="MsoNormal">authentication_timeout = 60</p>
<p class="MsoNormal">
# Delay in
seconds to complete client authentication</p>
<p class="MsoNormal">
# 0 means
no timeout.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">
</p>
<p class="MsoNormal">-rw-r--r--. 1 apache root 42 feb 29
18:28 pool_passwd</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">postgres:5c0435eee0f211f150e980e459151xxx</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">-rwxrw-r--. 1 root root 3295 mar 3
18:19 pool_hba.conf</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"># TYPE DATABASE USER
CIDR-ADDRESS METHOD</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"># "local" is for Unix domain socket connections
only</p>
<p class="MsoNormal">local all all
md5</p>
<p class="MsoNormal"># IPv4 local connections:</p>
<p class="MsoNormal">host all all
<a href="http://127.0.0.1/32">127.0.0.1/32</a>
md5</p>
<p class="MsoNormal">host all all
<a href="http://0.0.0.0/0">0.0.0.0/0</a>
md5</p>
<p class="MsoNormal">#host all all
::1/128
trust</p></div>