Hi Tatsuo, Ah, authentication.. I have noticed that the previous PGPOOL package ran as root, and this one as postgres. Perhaps that messes up the authentication.
I'll look into it and will get back to you, thanks! Ger. On Mon, 2010-01-18 at 09:52 +0100, Tatsuo Ishii wrote: > > Hi, > > > > I'm having a problem on one of the pgpool instances. When I try to connect > > through > > pgpool, it cannot connect. The other node's pgpool works fine, so both > > postgresql instances > > are up and running. > > The configuration is the same as used for the previous version, 2.2.5. > > > > --------%<-------- > > postg...@db3$ psql -p9999 database_name > > psql: could not send startup packet: Broken pipe <- seen this happen once > > > > postg...@db3$ psql -p9999 database_name > > psql: server closed the connection unexpectedly <- mostly I get this error > > This probably means the server terminated abnormally > > before or while processing the request. > > --------%<-------- > > Sounds like an authentication problem. Can you show us pgpool.conf and > pg_hba.conf of PostgreSQL on db3? > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > > > Going directly to the local database, it works: > > > > --------%<-------- > > postg...@db3$ psql -p5433 database_name > > Welcome to psql 8.3.1, the PostgreSQL interactive terminal. > > > > Type: \copyright for distribution terms > > \h for help with SQL commands > > \? for help with psql commands > > \g or terminate with semicolon to execute query > > \q to quit > > > > database_name=# > > --------%<-------- > > > > The /var/log/pgpool.log is flooded with the following entries: > > --------%<-------- > > 2010-01-18 08:46:19 LOG: pid 11692: Cannot accept() new connection. all > > backends are down > > 2010-01-18 08:46:20 LOG: pid 12526: Cannot accept() new connection. all > > backends are down > > --------%<-------- > > > > pcp_node_info: > > --------%<-------- > > [r...@db3 pgpool-II]# pcp_node_info 30 db3 9898 pgpool password 0 > > db2 5433 3 1073741823.500000 > > [r...@db3 pgpool-II]# pcp_node_info 30 db3 9898 pgpool password 1 > > db3 5433 3 1073741823.500000 > > --------%<-------- > > > > Server info: > > --------%<-------- > > [r...@db3 pgpool-II]# rpm -qa | egrep 'pgpool|postgres' > > postgresql-devel-8.3.1-1PGDG.rhel5 > > postgresql-contrib-8.3.1-1PGDG.rhel5 > > compat-postgresql-libs-4-1PGDG.rhel5 > > postgresql-8.3.1-1PGDG.rhel5 > > postgresql-server-8.3.1-1PGDG.rhel5 > > postgresql-libs-8.3.1-1PGDG.rhel5 > > postgresql-docs-8.3.1-1PGDG.rhel5 > > pgpool-II-2.3-1.rhel5 > > > > [r...@db3 pgpool-II]# cat /etc/redhat-release > > Red Hat Enterprise Linux Server release 5.4 (Tikanga) > > --------%<-------- > > > > Any help is very much appreciated. > > > > Thanks, > > Ger. > > > > _______________________________________________ > > Pgpool-general mailing list > > [email protected] > > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
