Search Postgresql Archives

Problem with connecting with named host parameter

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

 



Hi
I am getting the following error when I connect with hostname on localhost

psql -h capture -U <dbuser> -p 5432 <dbname>
psql: error: FATAL:  no pg_hba.conf entry for host "fe80::7285:c2ff:feb0:cd4%eth0", user "usevideo", database "usevideos", SSL off

The hba.conf is

local   all             all                                     password
# IPv4 local connections:
host    all             all             127.0.0.1/24            password
host all        all     192.0.0.0/0     password
# IPv6 local connections:
host    all             all             ::1/128                 trust

If I change -h to ip address then it works, just not with hostname.
Connecting from another host also works.

The other thing I cant understand if the
"fe80::7285:c2ff:feb0:cd4%eth0"

This looks like an ipv6 host or block id which I caant understand.
This is with pg 11 and 12 on fedora 34

[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