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

Поиск
Список
Период
Сортировка
От Stephan Knauss
Тема Re: Psql wants to use IP6 when connecting to self using tcp...
Дата
Msg-id 87baf008-b06c-cb5a-55fb-df371651d049@stephans-server.de
обсуждение исходный текст
Ответ на Psql wants to use IP6 when connecting to self using tcp...  (Jerry Levan <jerry.levan@gmail.com>)
Список pgsql-general
On 22.06.2021 02:44, 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
 
> [...]
> Netstat shows that Postgres is listening on a ip6 interface.

You stated earlier, that you instructed PostgreSQL to listen to all 
interfaces. This includes IPv6. Your configuration misses to configure 
trust for your IPv6 network.

Alternatively you can change your network configuration to run on IPv4 
and not use IPv6. You would remove the IPv6 interface from PostgreSQL 
and change resolver to return IPv4 (A record, not AAAA) for your host.

Stephan





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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Psql wants to use IP6 when connecting to self using tcp...
Следующее
От: Niels Jespersen
Дата:
Сообщение: cpu-intensive immutable function and parallel scan