Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Today I upgraded my Fedora system to Fedora 35 which included an upgrade to
PostgreSQL 13.x.x.
I did an initdb and restored my existing db from a dump. 

I modified pg_hba.conf to allow access machines on my local network
host    all             all             192.168.1.0/24          trust
I modified postgresql.conf to listen to all interfaces.

 Localhost works...
[jerry@bigbox ~]$ psql
psql (13.3)
Type "help" for help.

levan=# \q
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

Using the ip4 address of bigbox works
[jerry@bigbox ~]$ psql -h 192.168.1.75
psql (13.3)
Type "help" for help.

lxxx=# 

I can connect to/from the other machines in my local network...
Netstat shows that Postgres is listening on a ip6 interface.

What  did I have to do get the 'fatal' above case to work?

Trapped in Steve Jobs Reality Distortion Field





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux