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

[vinod rathod]

Hi,

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
pool_hba.conf

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>