[pgpool-general: 9267] pool_passwd authentication failed

[김동영]

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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20241111/ac357062/attachment.htm>