[pgpool-general: 8982] Re: Setup pgpool with no pool_hba and let postgresql do the authentication?
Tatsuo Ishii
ishii at sraoss.co.jp
Sat Dec 9 07:34:29 JST 2023
> All;
>
>
> What is the proper way / config to not use the pool_hba and
> pool_passwd files (disable pg pool from doing any authentication) and
> simply let the backend PostgreSQL nodes do the authentication?
You can use the clear text password authentication.
https://www.pgpool.net/docs/44/en/html/auth-methods.html#AUTH-PASSWORD
You can also use allow_clear_text_frontend_auth.
https://www.pgpool.net/docs/44/en/html/runtime-config-connection.html#GUC-ALLOW-CLEAR-TEXT-FRONTEND-AUTH
The former is most recommended because you can force clients to use
SSL. Clear text password is not safe without using SSL.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
More information about the pgpool-general
mailing list