[pgpool-general: 9317] Issue with Password Authentication for Pgpool

[vijay patil]

Hello Everyone,

Need assistance on below requirements.

My requirement is to prompt for a password when connecting through Pgpool
(port 9999) and to avoid using the pool_password file. However, I’m
currently getting the error related to the lack of an entry in the
pool_passwd file.

Could you please advise how I can achieve password authentication without
using the pool_password file, while ensuring that Pgpool prompts for the
password during connection?


Here is the relevant configuration from my pool_hba.conf:


host    all         all         10.125.0.90/32       trust
# Node 1host    all         all         10.125.0.91/32       trust
       # Node 2#host    all         all         10.125.0.79/32
scram-sha-256    # Node 3host    all         all         0.0.0.0/0
       scram-sha-256    # All nodes

error :-
[postgres at scrbtrheldbaas002 PG_DATA]$ psql -h 10.125.0.79 -U vkp -d
postgres -p 9999
psql: error: connection to server at "10.125.0.79", port 9999 failed:
FATAL:  SCRAM authentication failed
DETAIL:  pool_passwd file does not contain an entry for "vkp"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20250109/7f852437/attachment.htm>