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>
Re: Psql wants to use IP6 when connecting to self using tcp... Tom Lane <tgl@sss.pgh.pa.us>
Re: Psql wants to use IP6 when connecting to self using tcp... "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: 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... Tom Lane <tgl@sss.pgh.pa.us>
Re: Psql wants to use IP6 when connecting to self using tcp... "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Psql wants to use IP6 when connecting to self using tcp... Tom Lane <tgl@sss.pgh.pa.us>
Re: Psql wants to use IP6 when connecting to self using tcp... Alan Hodgson <ahodgson@lists.simkin.ca>
Re: Psql wants to use IP6 when connecting to self using tcp... Stephan Knauss <pgsql@stephans-server.de>
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", SSL off > [...] > 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
Дата:
