pgpool

pgpoolAdmin - superuser: unknow (connetion error)

After login i got following message.

enter image description here

create -> /var/www/.pcppass

 #insert:hostname:port:username:password

 *:*:admin:postgres
 *:*:postgres:postgres
 *:*:administrator:postges


 host$ sudo chown www-data .pcppass

... and it don't works :-/

Solution

  • After long time searching it seems the issue is related to pg_hba.conf and pool_hba.conf incompatibility when using wrong combinations of trusted and md5 host entries. See here and the FAQ. Those links shows how to correctly pair both conf files with this matrix :

    enter image description here

    You have to set default entries according to this matrix in order to get the so called "superuser" in pgpoolAdmin to be enabled and also to be able to allow connection throught pgpool.

    I also found this answer here that helped me finally achieving to enable correct connection to backend servers: I had to mark the pgpool server as a trusted server on local network on pg_hba.conf on my postgresql servers.