<div dir="auto"><div dir="auto">Hi,</div><div dir="auto"><br></div><div dir="auto">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</div><div dir="auto"><br></div><div dir="auto">If you are using the failover mechanism then you need to mention the master-slave entry in pgpool.conf file.</div><div dir="auto"><br></div><div dir="auto">Hope this helps.</div><div dir="auto"><br></div><div dir="auto">Sent from my iPhone.</div></div><br><div class="gmail_quote"><div dir="ltr">On Sun, Nov 18, 2018, 11:36 PM Nitish Kumar <<a href="mailto:itcell.mpwz@mp.gov.in">itcell.mpwz@mp.gov.in</a> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi All,<div><br></div><div>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.</div><div><br></div><div>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.</div><div><br></div><div>Should I make entry by PgPool II 's IP and corresponding users or</div><div>I should make entry of actual client's IP which will connect to PgPool ?</div><div><br></div><div>Hoping for good clarification and guidance.</div><div><br></div><div>Regards,</div><div>Nitish Kumar </div>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank" rel="noreferrer">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</blockquote></div>