Re: Issue with Password Authentication for Pgpool - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: Issue with Password Authentication for Pgpool
Date
Msg-id 20250109.162319.54775553046195699.ishii@postgresql.org
Whole thread Raw
In response to Re: Issue with Password Authentication for Pgpool  (vijay patil <vijay.postgres@gmail.com>)
List pgsql-general
> 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




pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Issue with Password Authentication for Pgpool
Next
From: vijay patil
Date:
Subject: Re: Issue with Password Authentication for Pgpool