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

[Tatsuo Ishii]

> Hello, I performed a reload using systemctl reload pgpool. (The reload
> command is as follows.) /usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf reload

Strange. That should have made each pgpool process re-open pool_passwd
(pgpool does not have cache of pool_passwd) and upon authentication
request pgpool should read the latest contents of pool_passwd. I'll
look into this more.

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

> 2024년 11월 11일 (월) 15:33, Tatsuo Ishii <ishii at postgresql.org>님이 작성:
> 
>> > 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
>>