[Pgpool-general] Startup Issue

DM dm.aeqa at gmail.com
Thu Jun 18 20:37:32 UTC 2009


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090618/7d442ad9/attachment.html>


More information about the Pgpool-general mailing list