[pgpool-general: 8982] Re: Setup pgpool with no pool_hba and let postgresql do the authentication?

[Tatsuo Ishii]

> 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