Postgres Pro
Downloads
Home   >   mailing lists

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

From Stephan Knauss
Subject Re: Psql wants to use IP6 when connecting to self using tcp...
Date
Msg-id 87baf008-b06c-cb5a-55fb-df371651d049@stephans-server.de
Whole thread Raw
In response to Psql wants to use IP6 when connecting to self using tcp...  (Jerry Levan <jerry.levan@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Psql wants to use IP6 when connecting to self using tcp...
Next
From: Niels Jespersen
Date:
Subject: cpu-intensive immutable function and parallel scan