Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL HA - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: PostgreSQL HA
Date
Msg-id CAGDYbUPF5K5K4zKWB9yzwnvY63+wrN+ZimYy=u_d-ZvzvD+kOA@mail.gmail.com
Whole thread Raw
In response to PostgreSQL HA  (Pierre Ochsenbein <pierreochsenbein@gmail.com>)
List pgsql-admin
Tree view
Hi Pierre,

You can add your pgpool Ip in pg_hba.conf  file and reload the DB server as shown below.

host    template1            username        10.1.24.11/32        trust


Hope this helps.



On Wed, Jul 18, 2018 at 7:23 PM, Pierre Ochsenbein <pierreochsenbein@gmail.com> wrote:
Hi all,

I have any database like template1 but I can see this output in my log file....

-bash-4.2$ tail -f postgresql-Wed.log
2018-07-18 09:41:19.189 EDT [9120] FATAL:  no pg_hba.conf entry for host "10.1.24.11", user "nobody", database "template1", SSL off
2018-07-18 09:41:19.194 EDT [9121] FATAL:  no pg_hba.conf entry for host "10.1.24.11", user "nobody", database "template1", SSL off

I need to add an entry for the host .11 which is the pgpool?

Thanks,
Pierre


pgsql-admin by date:

Previous
From: Chris Zandstra
Date:
Subject: Re: Query Tool Initialize Error
Next
From: bala jayaram
Date:
Subject: logical decoding cannot be used while in recovery 9.5