[pgpool-general: 9356] Re: pgpool 4.5.5 can't reach stand by server

[Tatsuo Ishii]

Hello Mauricio,

> Hola Tatsuo
> 
> I've tried the command
> 
> [postgres at buda pgpool-II]$ pcp_attach_node -p 9898 -h localhost 1
> FATAL:  authentication failed for user "postgres"
> DETAIL:  username and/or password does not match

Have you created pcp_conf? pcp commands require pcp_conf for their
authentication (separate from pgpool.conf or pool_passwd).

https://www.pgpool.net/docs/latest/en/html/configuring-pcp-conf.html

> May be this authentication error is the source problem at all..
> 
> Right now, the pgpool.conf setting have the following:
> 
> sr_check_period = 10
> sr_check_user = 'postgres'
> sr_check_password = 'the_postgres_passw'
> 
> health_check_user = 'postgres'
> health_check_password = ' the_postgres_passw'
> health_check_database = 'postgres'
> 
> Initially I had let the passwords parameters empty '' and set the passwords
> through
> 
> pg_enc -m -f /etc/pgpool-II/pgpool.conf -u postgres -k
> /var/lib/pgsql/.pgpoolkey
> 
> [postgres at buda pgpool-II]$ cat pool_passwd
> postgres:AESSW1V5WTuP1xf1xFenoLDhA==
> 
> Obviously didn't work...
> 
> I'm assuming one of the check users (sr or health ) is  used by pgpool.

This should work. What kind of errors do you see in pgpool.log?

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp