<div dir="ltr"><p class="MsoNormal"><span lang="EN-US">Dears, I
have this problem and cannot find the solution , I hope you can help me</span></p>
<p class="MsoNormal"><span lang="EN-US">Postgres
version 9.4.4</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">Pgpool
version 3.4.3</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">I follow
this tutorial</span></p>
<p class="MsoNormal"><span lang="EN-US"><a href="http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html">http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html</a></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">I have
superuser: unknown (Connection error) in pgpoolAdmin</span></p>
<p class="MsoNormal"><span lang="EN-US">The query
is trying to run Pgpool is as follows</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">psql -p
9999 -U postgres -W template1 -c "SELECT usesuper FROM pg_user WHERE
usename = 'postgres' </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">but the
port 9999 is the problem i have!!!</span></p>
<p class="MsoNormal"><span lang="EN-US">With 5432
everything is ok</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">I send mi
pg_hba.conf and pool_hba.conf</span></p>
<p class="MsoNormal"><span lang="EN-US">Im try with
pool_hba on and pool_hba off in pgpool.conf</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">TYPE
DATABASE
USER
ADDRESS
METHOD</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">#
"local" is for Unix domain socket connections only</span></p>
<p class="MsoNormal"><span lang="EN-US">local
all
all
trust</span></p>
<p class="MsoNormal"><span lang="EN-US"># IPv4
local connections:</span></p>
<p class="MsoNormal"><span lang="EN-US">host
all
all
<a href="http://127.0.0.1/32">127.0.0.1/32</a> trust</span></p>
<p class="MsoNormal"><span lang="EN-US"># IPv6
local connections:</span></p>
<p class="MsoNormal"><span lang="EN-US">host
all
all
::1/128
trust</span></p>
<p class="MsoNormal"><span lang="EN-US"># Allow all
users from all addresses</span></p>
<p class="MsoNormal"><span lang="EN-US">host
all
all
<a href="http://0.0.0.0/0">0.0.0.0/0</a>
trust</span></p>
<p class="MsoNormal"><span lang="EN-US"># Allow
replication connections from localhost, by a user with the</span></p>
<p class="MsoNormal"><span lang="EN-US">#
replication privilege.</span></p>
<p class="MsoNormal"><span lang="EN-US">#local
replication
postgres
trust</span></p>
<p class="MsoNormal"><span lang="EN-US">host
replication replication
<a href="http://0.0.0.0/0">0.0.0.0/0</a>
trust</span></p>
<p class="MsoNormal"><span lang="EN-US">#host
replication
postgres
::1/128
trust</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">#
TYPE DATABASE
USER
CIDR-ADDRESS METHOD</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">#
"local" is for Unix domain socket connections only</span></p>
<p class="MsoNormal"><span lang="EN-US">local
all
all
trust</span></p>
<p class="MsoNormal"><span lang="EN-US"># IPv4
local connections:</span></p>
<p class="MsoNormal"><span lang="EN-US">host
all
all
<a href="http://0.0.0.0/0">0.0.0.0/0</a>
trust</span></p>
<p class="MsoNormal"><span lang="EN-US">host
all
all
::1/128
trust</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">-bash-4.2$
psql -p 5432 -U postgres -W template1 -c "SELECT usesuper FROM pg_user
WHERE usename = 'postgres'";</span></p>
<p class="MsoNormal">Contraseña para usuario postgres:</p>
<p class="MsoNormal">usesuper</p>
<p class="MsoNormal">----------</p>
<p class="MsoNormal"><span lang="EN-US">t</span></p>
<p class="MsoNormal"><span lang="EN-US">(1 fila)</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">-bash-4.2$
psql -p 9999 -U postgres -W template1 -c "SELECT usesuper FROM pg_user
WHERE usename = 'postgres'";</span></p>
<p class="MsoNormal">Contraseña para usuario postgres:</p>
<p class="MsoNormal">psql: no se pudo conectar con el servidor: No existe el
fichero o el directorio</p>
<p class="MsoNormal"> ¿Está el servidor
en ejecución localmente y aceptando</p>
<p class="MsoNormal"> conexiones en el
socket de dominio Unix «/var/run/postgresql/.s.PGSQL.9999»?</p></div>