> 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?
Ok. Do you see any error messages in PostgreSQL log? If so, could you please give it to me? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
