Обсуждение: PostgreSQL HA
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
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
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 offI need to add an entry for the host .11 which is the pgpool?Thanks,Pierre