[pgpool-general: 8143] Re: transparent authentication

Nikola(HM) nikm71 at hotmail.com
Tue May 10 20:20:17 JST 2022


There is another questions on this.

This row "hostssl all all all password" in pool_hba.conf file works only 
for frontend clients which connects to Pgpool. But it doesn't affect on 
connect to backend form Pgpool to PostgreSQL. Am I thinking right?


On 09.05.2022 03:44, Bo Peng wrote:
> Hello,
>> Our Pgpool is working in Kubernetes and it is doing role of sql queries
>> load balancer. In the same time postgresql servers, that are managed by
>> patroni, are working in their own virtual machines.
>> I would like ask - could current release Pgpool now perform transparent
>> authentication from clients pf the Pgpool to PostgreSQL server?
> Does "transparent authentication" mean that authentication is performed without generating pool_passwd file?
> If so, you can set "password" authentication and force SSL on all connections in pool_hba.conf:
>    hostssl    all    all    all    password
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general

More information about the pgpool-general mailing list