[pgpool-general: 12] posgres 9.1 streaming replication and pgpool-II configuration.

Sean Patronis spatronis at add123.com
Thu Dec 1 07:12:42 JST 2011


I have looked around at the documentation on configuring postgres 
streaming replication and pgpool, and now I am getting these errors in 
our test scenario.

I have started with a working postgres 9.1 streaming replication 
configuration and just attempted to add pgpool on top of it.  I have 
used pgpool.conf.sample-stream as the base for my config, and edited 
where necessary.  Postgres port 5432 is accesible from the host running 
pgpool (I have gotten basic load balancing working with pgpool prior to 
this)


when I run pgpool i get the following errors:

[root at dbnew etc]# pgpool -n -D
2011-11-30 16:55:01 LOG:   pid 37930: Backend status file 
/tmp/pgpool_status discarded
2011-11-30 16:55:01 LOG:   pid 37930: pgpool-II successfully started. 
version 3.1 (hatsuiboshi)
2011-11-30 16:55:01 ERROR: pid 37930: s_do_auth: expecting R got E
2011-11-30 16:55:01 ERROR: pid 37930: make_persistent_db_connection: 
s_do_auth failed
2011-11-30 16:55:01 ERROR: pid 37930: find_primary_node: 
make_persistent_connection failed
2011-11-30 16:55:01 ERROR: pid 37964: s_do_auth: expecting R got E
2011-11-30 16:55:01 ERROR: pid 37964: make_persistent_db_connection: 
s_do_auth failed
2011-11-30 16:55:01 ERROR: pid 37964: check_replication_time_lag: could 
not connect to DB node 0, check health check configuration

clearly something is not configured correctly, what gives?

Thanks.


More information about the pgpool-general mailing list