| From: | Stephan Knauss <pgsql(at)stephans-server(dot)de> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Psql wants to use IP6 when connecting to self using tcp... |
| Date: | 2021-06-22 05:58:02 |
| Message-ID: | 87baf008-b06c-cb5a-55fb-df371651d049@stephans-server.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 22.06.2021 02:44, Jerry Levan wrote:
> The below fails... the 'fe80....' is the ip6 address of big box.
> [jerry(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Niels Jespersen | 2021-06-22 07:06:10 | cpu-intensive immutable function and parallel scan |
| Previous Message | Tom Lane | 2021-06-22 01:23:47 | Re: Psql wants to use IP6 when connecting to self using tcp... |