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

[Takuma Hoshiai]

Hi,

On Sun, 18 Nov 2018 23:35:33 +0530
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 ?

The pg_hba.conf entry describes the IP address of the client as seen from PostgreSQL.
If you connect PostgreSQL only through Pgpool-II, make entry by Pgpool-II 's IP and corresponding user.
 
> Hoping for good clarification and guidance.
> 
> Regards,
> Nitish Kumar

Best Regards,
-- 
Takuma Hoshiai <hoshiai at sraoss.co.jp>