Date: Thu, 09 Jan 2025 16:23:19 +0900 (JST)
Message-Id: <20250109.162319.54775553046195699.ishii@postgresql.org>
To: vijay.postgres@gmail.com
Cc: david.g.johnston@gmail.com, pgsql-general@lists.postgresql.org
Subject: Re: Issue with Password Authentication for Pgpool
From: Tatsuo Ishii <ishii@postgresql.org>
In-Reply-To: <CAD5k+7z7ns134qsF7hrxGXqWKZ-GCPeZaTePx0FowH_GG55+_A@mail.gmail.com>
References: <CAD5k+7yM3EgYOU8XqzaF9fNTZoLeYb=ocPjgSBt+_1w4hvuDTw@mail.gmail.com>
	<CAKFQuwZsKF+Sq+OHaiZrwZLCabLqkuh81N6-o9peYjc52reNwQ@mail.gmail.com>
	<CAD5k+7z7ns134qsF7hrxGXqWKZ-GCPeZaTePx0FowH_GG55+_A@mail.gmail.com>
Mime-Version: 1.0
Content-Type: Text/Plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/20250109.162319.54775553046195699.ishii%40postgresql.org>
Precedence: bulk

> If we plan to use pool_hba.conf, then we must use the pool_passwd file to
> maintain passwords for all database users. This approach requires that
> every time a new user is created, their password is added to the pool_passwd
> file.

Not really. You can use pool_hba.conf with the auth method to
'password'. With this setting, if a passowrd is not found in
pool_passwd, then pgpool asks the password to PostgreSQL.

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