[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