[pgpool-general: 4083] superuser: unknown (Connection error) PgPoolAdmin

[Daniel Gallo]

Dears, I have this problem and cannot find the solution , I hope you can
help me

Postgres version 9.4.4



Pgpool version 3.4.3



I follow this tutorial

http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html



I have superuser: unknown (Connection error) in pgpoolAdmin

The query is trying to run Pgpool is as follows



psql -p 9999 -U postgres -W template1 -c "SELECT usesuper FROM pg_user
WHERE usename = 'postgres'



but the port 9999 is the problem i have!!!

With 5432 everything is ok



I send mi pg_hba.conf and pool_hba.conf

Im try with pool_hba on and pool_hba off in pgpool.conf









TYPE  DATABASE        USER            ADDRESS                 METHOD



# "local" is for Unix domain socket connections only

local   all             all                                     trust

# IPv4 local connections:

host    all             all             127.0.0.1/32            trust

# IPv6 local connections:

host    all             all             ::1/128                 trust

# Allow all users from all addresses

host    all             all             0.0.0.0/0               trust

# Allow replication connections from localhost, by a user with the

# replication privilege.

#local   replication     postgres                                trust

host     replication     replication      0.0.0.0/0              trust

#host    replication     postgres        ::1/128                 trust







# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD



# "local" is for Unix domain socket connections only

local   all         all                               trust

# IPv4 local connections:

host    all         all         0.0.0.0/0             trust

host    all         all         ::1/128               trust





-bash-4.2$ psql -p 5432 -U postgres -W template1 -c "SELECT usesuper FROM
pg_user WHERE usename = 'postgres'";

Contraseña para usuario postgres:

usesuper

----------

t

(1 fila)



-bash-4.2$ psql -p 9999 -U postgres -W template1 -c "SELECT usesuper FROM
pg_user WHERE usename = 'postgres'";

Contraseña para usuario postgres:

psql: no se pudo conectar con el servidor: No existe el fichero o el
directorio

        ¿Está el servidor en ejecución localmente y aceptando

        conexiones en el socket de dominio Unix
«/var/run/postgresql/.s.PGSQL.9999»?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20151002/117e208f/attachment.html>