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

[Tatsuo Ishii]

> 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?

Yes, you have problem with configuration. To check this please make
sure that you can connect from the host pgpool is running on as user =
sr_check_user, password = sr_check_password to database "postgres" by
using psql or whatever client you like.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp