[pgpool-general: 8136] Re: transparent authentication

Bo Peng pengbo at sraoss.co.jp
Mon May 9 09:44:09 JST 2022


> 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

More information about the pgpool-general mailing list