Re: FATAL error in logs: no pb_hba.conf entry

On 4/29/21 8:39 PM, james terris wrote:
> Hello,
> I have a postgres version 9.6 server running on and old Windows Server
> 2008 R2 server.

An *EOL* Windows Server...  Don't feel too bad: I've got to manage SQL
Server 2005 on Win 2008 R2; earlier this year, we just migrated SQL Server
2000 to 2016.

> 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.

It means exactly what it says: some process is trying to log in as user
APPSERVER$ from the IPv6 loopback device.  This is a security concern.  Look
in the Windows Event logs for that user, ask the Windows sysadmins, and the
end users who care about this.

> My pg_hba.conf looks like this:
>
> host    all   postgres 127.0.0.1/32   md5
> host anotherDB   anotherUser    127.0.0.1/32   md5
> host all   postgres    ::1/128   md5
> host anotherDB anotherUser ::1/128  md5

--
Angular momentum makes the world go 'round.