[pgpool-general: 6292] Re: PgPool and PostgreSQL pg_hba.conf

vinod rathod vinodr820 at gmail.com
Mon Nov 19 14:40:10 JST 2018


You have to make an entry of your pgpool-II Ip in pg_hba.conf file  along
with respective application user and database Master/slave entry  in

If you are using the failover mechanism then you need to mention the
master-slave entry in pgpool.conf file.

Hope this helps.

Sent from my iPhone.

On Sun, Nov 18, 2018, 11:36 PM Nitish Kumar <itcell.mpwz at mp.gov.in wrote:

> Hi All,
> I am using PgPool II 3.5 with PostgreSQL 10.5 in my production cluster.
> PgPool II is running in Load Balancing with Master/Slave Streaming
> replication mode with Connection Pooling set to OFF.
> All my traffic to backend PostgreSQL is going through PgPool II. I am
> confused as to what should I enter in pg_hba.conf of my databases.
> Should I make entry by PgPool II 's IP and corresponding users or
> I should make entry of actual client's IP which will connect to PgPool ?
> Hoping for good clarification and guidance.
> Regards,
> Nitish Kumar
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20181119/4a3b8a45/attachment.html>

More information about the pgpool-general mailing list