[Pgpool-general] No nodes shown in pgPoolAdmin

[Dave Page]

Hi Tatuso

On Mon, Nov 15, 2010 at 12:38 AM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> What user id does your apache use(maybe "apache")? PgpoolAdmin need to
> access PostgreSQL while health checking. I suspect that the user role
> is not registered in PostgreSQL.

Yes, it's apache:

$ ps -ef |grep apache
ec2-user 10291 10272  0 08:50 pts/1    00:00:00 grep apache
apache   15411 13816  0 Nov14 ?        00:00:00 /usr/sbin/httpd
...
apache   18658     1  0 Nov14 ?        00:00:02 /usr/local/bin/pgpool
-f /usr/local/etc/pgpool.conf -F /usr/local/etc/pcp.conf -D -d -n
apache   18659 18658  0 Nov14 ?        00:00:00 pgpool: wait for
connection request
...

The user is present in PostgreSQL however:

postgres=# select * from pg_user;
 usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  |
valuntil | useconfig
----------+----------+-------------+----------+-----------+----------+----------+-----------
 postgres |       10 | t           | t        | t         | ******** |
         |
 apache   |    16394 | f           | f        | f         | ******** |
         |
(2 rows)

The pg_hba.conf file has:

# TYPE  DATABASE        USER            CIDR-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
# Open Season!
host    all             all             0.0.0.0/0               md5

So, the apache user should be able to connect via the Unix socket or
loopback addresses.

Do you have any other ideas, or can I provide any more information?

Thanks!

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company