[pgpool-general: 20] Re: posgres 9.1 streaming replication and pgpool-II configuration.
Tatsuo Ishii
ishii at postgresql.org
Fri Dec 2 07:36:51 JST 2011
> 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
> [root at dbnew etc]# psql -Ureplicator -W postgres
> Password for user replicator:
> psql (9.1.1)
> Type "help" for help.
>
> postgres=> select tablename from pg_tables where tableowner='postgres'
> limit 5;
> tablename
> --------------
> pg_statistic
> pg_type
> pg_attribute
> pg_authid
> pg_proc
> (5 rows)
>
> postgres=> \q
>
>
>
> It can also connect to the streaming replicated postgres server on
> another host:
>
> [root at dbnew etc]# psql -Ureplicator -W -h db2.internaltest.com
> postgres
> Password for user replicator:
> psql (9.1.1)
> SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
> Type "help" for help.
>
> postgres=> select tablename from pg_tables where tableowner='postgres'
> limit 5;
> tablename
> --------------
> pg_statistic
> pg_type
> pg_attribute
> pg_authid
> pg_proc
> (5 rows)
>
> postgres=> \q
>
>
> I have even enabled that user to connect without a password and I
> still get the same error. What else can I look for to fix this error?
>
> Thanks.
More information about the pgpool-general
mailing list