Re: Issue with Password Authentication for Pgpool

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: vijay(dot)postgres(at)gmail(dot)com
Cc: david(dot)g(dot)johnston(at)gmail(dot)com, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Issue with Password Authentication for Pgpool
Date: 2025-01-09 07:23:19
Message-ID: 20250109.162319.54775553046195699.ishii@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message vijay patil 2025-01-09 07:36:29 Re: Issue with Password Authentication for Pgpool
Previous Message Tatsuo Ishii 2025-01-09 07:19:32 Re: Issue with Password Authentication for Pgpool