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

[Sean Patronis]

On 12/01/2011 05:36 PM, Tatsuo Ishii wrote:
>> On 11/30/2011 06:12 PM, Tatsuo Ishii wrote:
>>>> 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
>>>
>> pgpool is running on the master database server and the sr_check_user
>> can connect to the postgres database just fine:
> What is backend_hostname0? If it is other than '', you need something like:
>
> psql -Ureplicator -h backend_hostname0 -W  postgres
>
> Also, do you see any error message regarding client connections in the
> PostgreSQL log?
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>

I had actually put the many things in for backend_hostname0 (localhost, 
the IP address, etc), but never tried to leave it blank.  That seemed to 
fix it and get things straight.

Thanks!