[pgpool-general: 2669] help with load balancing configuration

[jeff mccormick]

Hello,

I am trying to configure the most recent version of pgpool to
do load-balancing between a pg 9.3.2 master and standby
that are configured for streaming replication.

My configuration appears to load balance correctly across
the 2 nodes (master and standby) during normal operations.

However, when I shut down the standby node, the pgpool
will no longer work or allow connections to be made to
the master node which is still up.

The pgpool logs states the following:

2014-03-27 18:54:04 ERROR: pid 17525: pool_read: EOF encountered with
backend
2014-03-27 18:54:04 ERROR: pid 17525: s_do_auth: error while reading
message kind
2014-03-27 18:54:04 ERROR: pid 17525: make_persistent_db_connection:
s_do_auth failed
2014-03-27 18:54:04 ERROR: pid 17525: check_replication_time_lag: could not
connect to DB node 1, check sr_check_user and sr_check_password

pgpool defintely detects the shutdown of the standby node, but I would still
like to be able for it to allow connections to the master.

Is it possible for pgpool to allow connections to the master while the
standby is shutdown?  I am probably missing some configuration option
and any help would be appreciated.  Attached is my pgpool.conf

Jeff


-- 
*Jeff McCormick*
843-327-5754
jeffmc04 at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140327/962b5291/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 30726 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140327/962b5291/attachment-0001.obj>