Hi >> We have a single postgres server that was under load. To try help with >> the load I stuck pgpool in front of postgres (using connection caching) >> >> But every few hours everything seems to go pear shaped. pgpool seems to >> get "Connection reset by peer" and postgres gets some errors and kills >> all its sessions then starts again. >> >> Here are the logs: >> >> Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 ERROR: pid 8117: >> pool_read: read failed (Connection reset by peer) >> Jan 3 08:00:29 ips01 pgpool: 2008-01-03 08:00:29 ERROR: pid 8117: >> ProcessFrontendResponse: failed to read kind from frontend. fronend >> abnormally exited > > It seems that a client program call exit() before doing PQfinish(). > Do you use persistent connection (pconnect() in PHP)?
We're using IIS with a postgres ODBC driver :/ -- Adrian Moisey System Administrator | CareerJunction | Your Future Starts Here. Web: www.careerjunction.co.za | Email: [EMAIL PROTECTED] Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
