Issue with Password Authentication for Pgpool

From: vijay patil <vijay(dot)postgres(at)gmail(dot)com>
To: pgpool-general(at)pgpool(dot)net, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Issue with Password Authentication for Pgpool
Date: 2025-01-09 05:06:31
Message-ID: CAD5k+7yAt2bMUpgcEsDEvtJZA2yhre8_ENjjrWZ6VRjy5J8vzQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2025-01-09 05:17:35 Re: Issue with Password Authentication for Pgpool
Previous Message Ron Johnson 2025-01-08 20:19:31 Re: INTERVAL MINUTE TO SECOND didn't do what I thought it would do