[pgpool-general: 8144] Re: transparent authentication

Tatsuo Ishii ishii at sraoss.co.jp
Tue May 10 21:15:49 JST 2022


Hi,

> 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?

Yes, your thinking is correct.

Best reagards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> 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
>>
> _______________________________________________
> 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