Re: Psql wants to use IP6 when connecting to self using tcp... - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: Psql wants to use IP6 when connecting to self using tcp...
Date
Msg-id 20210623175127.GB27765@hjp.at
Whole thread Raw
In response to Psql wants to use IP6 when connecting to self using tcp...  (Jerry Levan <jerry.levan@gmail.com>)
Responses Re: Psql wants to use IP6 when connecting to self using tcp...
List pgsql-general
On 2021-06-21 19:44:16 -0500, Jerry Levan wrote:
> The below fails... the 'fe80....' is the ip6 address of big box.
> [jerry@bigbox ~]$ psql -h bigbox
> psql: error: FATAL:  no pg_hba.conf entry for host "fe80::fe3f:dbff:fed1:f62e%enp7s0", user "lxxx", database "lxxx",
SSLoff 

This looks like a configuration error in your DNS. FE80:... is a
link-local address, and you generally don't want them in DNS. Either
remove that completely (as others have already suggested) or replace if
with the global unicast (or at least unique local) IPv6 address (and
then add that to pg_hba.conf).

If the address isn't in DNS, check your /etc/hosts.

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: How to hash a large amount of data within Postgres?
Next
From: Dirk Krautschick
Date:
Subject: Is there something similar like flashback query from Oracle planned for PostgreSQL