[pgpool-general: 8138] Re: transparent authentication

Bo Peng pengbo at sraoss.co.jp
Mon May 9 15:04:13 JST 2022


Hello,

> Thank you for reply.
> 
> Could you tell where should pool_hba.conf file be placed  when I run 
> pgpool as:
>
> 1. docker image on Kubernetes platform
> 
> 2. docker image on virtual machine.

Does the docker image which you are using supports customization of pool_hba.conf?
 
> Thanks in advance.
> 
> 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
> >


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
http://www.sraoss.co.jp/


More information about the pgpool-general mailing list