[Pgpool-general] Problem with load balancing + automatic failover

[Yoshiyuki Asaba]

Hi,

From: "Michael SALOMON" <michaelsalomon78 at gmail.com>
Subject: [Pgpool-general] Problem with load balancing + automatic failover
Date: Tue, 29 Apr 2008 16:57:48 +0200

> Fact is, as backend_weight0 = 1 on MASTER server, there is no way I can run
> a SELECT statement on MASTER pgpool server, because it is 100% load balanced
> to
>  the actually failed database, and then I end up with :
> 
> - master server -> pgsql -h master -p 9999 -d rep_db -c 'SELECT * FROM
> my_table'
> psql:/usr/local/pgsql/sql/select.sql:2: server closed the connection
> unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> psql:/usr/local/pgsql/sql/select.sql:2: connection to server was lost

Could you show us pgpool log?

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp