[Pgpool-general] pcp_attach_node problem?

[Jaume Sabater]

On Thu, Jan 8, 2009 at 10:14 PM,  <Daniel.Crespo at l-3com.com> 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"