[pgpool-general: 8143] Re: transparent authentication

[Nikola(HM)]

Hello,

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?

Regards,
    Nikolay

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
>