[pgpool-general: 9268] Re: pool_passwd authentication failed

[Tatsuo Ishii]

> Hello, I have just subscribed to pgpool-general for the first time today. I
> am writing this email with a question. Currently, I am using PostgreSQL
> version 10.23-4 and PGPOOL-II version 4.2.10. There are three nodes in the
> DB Replication Cluster, and each node is monitored by Watchdog. (The actual
> operations run through the delegate IP of Watchdog.) Account authentication
> is managed with pool_passwd. Here is my question: When I create a new
> account or change an existing account's password and update pool_passwd, I
> encounter an error related to password authentication failure.
> Interestingly, if I try 10 times initially, all 10 attempts fail. Then,
> when I retry, about 7 attempts fail, then after retrying again, about 5
> attempts fail. Eventually, it connects successfully after several retries.
> Is there a chance that child processes are caching authentication
> information separately? How can I resolve this issue?

Have you executed "pgpool reload" or pcp_reload_config command after
changing pool_passwd?
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp