Обсуждение: PostgreSQL HA

Поиск
Список
Период
Сортировка

PostgreSQL HA

От
Pierre Ochsenbein
Дата:
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

Re: PostgreSQL HA

От
Shreeyansh Dba
Дата:
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