FATAL error in logs: no pb_hba.conf entry

From: james terris <james_terris(at)yahoo(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: FATAL error in logs: no pb_hba.conf entry
Date: 2021-04-30 01:39:36
Message-ID: 1566938499.2834154.1619746776214@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,I have a postgres version 9.6 server running on and old Windows Server 2008 R2 server.
I noticed this message in the logs:
FATAL: no pg_hba.conf entry for host "::1", user "APPSERVER$", database "postgres", SSL off

It's true that I don't have a row for the the "APPSERVER$" user but I'm not really sure where that user is coming from. It's the server name and it's only trying to log in via IPv6 ?
If someone could give me some more details about why is causing that log line that would be great. I have other servers configured without that line in pg_hba.conf and they don't have that FATAL message.
My pg_hba.conf looks like this:
host    all   postgres    127.0.0.1/32   md5host    anotherDB   anotherUser    127.0.0.1/32   md5
host    all   postgres    ::1/128   md5
host    anotherDB    anotherUser    ::1/128   md5

thank you,james
BTW, I'm new to this mailing list, if I have the wrong one please update me.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2021-04-30 03:21:22 Re: FATAL error in logs: no pb_hba.conf entry
Previous Message Godfrin, Philippe E 2021-04-29 21:20:03 RE: [EXTERNAL] Re: WALWriteLocks