[pgpool-general: 6292] Re: PgPool and PostgreSQL pg_hba.conf
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.
> Nitish Kumar
> pgpool-general mailing list
> pgpool-general at pgpool.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general