| From: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> |
|---|---|
| To: | Pierre Ochsenbein <pierreochsenbein(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL HA |
| Date: | 2018-07-18 14:24:33 |
| Message-ID: | CAGDYbUPF5K5K4zKWB9yzwnvY63+wrN+ZimYy=u_d-ZvzvD+kOA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)gmail(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bala jayaram | 2018-07-18 14:31:07 | logical decoding cannot be used while in recovery 9.5 |
| Previous Message | Chris Zandstra | 2018-07-18 13:59:26 | Re: Query Tool Initialize Error |