From: james terris <james_terris@yahoo.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: FATAL error in logs: no pb_hba.conf entry
Date: Fri, 30 Apr 2021 01:39:36 +0000 (UTC)
Message-ID: <1566938499.2834154.1619746776214@mail.yahoo.com> (raw)
References: <1566938499.2834154.1619746776214.ref@mail.yahoo.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: james_terris@yahoo.com, pgsql-admin@lists.postgresql.org
Subject: Re: FATAL error in logs: no pb_hba.conf entry
In-Reply-To: <1566938499.2834154.1619746776214@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox