Re: Psql wants to use IP6 when connecting to self using tcp...

Поиск
Список
Период
Сортировка
От Peter J. Holzer
Тема Re: Psql wants to use IP6 when connecting to self using tcp...
Дата
Msg-id 20210623175127.GB27765@hjp.at
обсуждение исходный текст
Ответ на Psql wants to use IP6 when connecting to self using tcp...  (Jerry Levan <jerry.levan@gmail.com>)
Ответы Re: Psql wants to use IP6 when connecting to self using tcp...  (Jerry LeVan <jerry.levan@gmail.com>)
Список 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!"

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: How to hash a large amount of data within Postgres?
Следующее
От: Dirk Krautschick
Дата:
Сообщение: Is there something similar like flashback query from Oracle planned for PostgreSQL