> 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
