Hi All, i have 2 boxes 1. box - installed pgpool 2.2.2 and postgres 8.3.3 and 2. box - installed postgres 8.3.3
I successfully configured,but i am seeing error when i try to connect using pgpool for the first time I am getting the below error * psql -p9999* * psql: server closed the connection unexpectedly* * This probably means the server terminated abnormally* * before or while processing the request.* But when I try second time I can connect to the database.This only happens when I start the pgpool and try to connect. consecutive connections to pgpool is succsseful. The log files shows the below information 2009-06-18 12:34:28 LOG: pid 19367: pgpool successfully started 2009-06-18 12:34:32 LOG: pid 19388: connection received: host=[local] 2009-06-18 12:34:32 ERROR: pid 19388: connect_inet_domain_socket: connect() failed: Connection refused 2009-06-18 12:34:32 ERROR: pid 19388: connection to tp-dbs0000(2345) failed 2009-06-18 12:34:32 ERROR: pid 19388: new_connection: create_cp() failed 2009-06-18 12:34:32 LOG: pid 19388: notice_backend_error: 1 fail over request from pid 19388 2009-06-18 12:34:32 LOG: pid 19367: starting degeneration. shutdown host fppp-dbs0000(2345) 2009-06-18 12:34:32 LOG: pid 19367: failover_handler: set new master node: 0 2009-06-18 12:34:32 LOG: pid 19367: failover done. shutdown host tp-dbs0000(2345) 2009-06-18 12:34:34 LOG: pid 19434: connection received: host=[local] I am facing this problem in the old pgpool version 2.1. How to solve the above issue. Thanks Deepak
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
