On Thu, Jan 8, 2009 at 10:14 PM, <[email protected]> wrote: > And issue a SQL Select command on a table, like: > postgres=# select * from pg_stat_activity ; > > It returns: > postgres=# select 1; > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > The connection to the server was lost. Attempting reset: Succeeded. > > postgres=# select 1;
Some ideas: 1. Show us the logs. Full logs, but only the relevant parts (got tons of things to read every day here). :) 2. Check whether PostgreSQL is having some problem of some sort before blaming it on pgpool-II. Can you run the same queries on both nodes and get the same results? 3. Check permissions in both bg_hba.conf files. 4. Have you considered using version 8.3.5 of PostgreSQL and see how it goes? Or at least, the last revision of the 8.1 branch. -- Jaume Sabater http://linuxsilo.net/ "Ubi sapientas ibi libertas" _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
