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

2021-06-24 Thread Tom Lane
"Peter J. Holzer" writes: > On 2021-06-23 20:33:33 -0400, Tom Lane wrote: >> It's quite odd that nslookup isn't agreeing with glibc's name >> resolution code. > AFAIK nslookup uses only DNS. Glibc uses all methods in nsswitch.conf. Ah, right. So looking at a Fedora 34 installation, I see in /et

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

2021-06-24 Thread Peter J. Holzer
On 2021-06-23 20:33:33 -0400, Tom Lane wrote: > Jerry LeVan writes: > > bigbox has a freshly installed Fedora 34 system and it runs postgresql 13.3 > > > the following are being run ON bigbox > > > nslookup bigbox returns the correct ipv4 address > > nslookup bigbox.skynet returns the correct i

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

2021-06-23 Thread Alan Hodgson
On Wed, 2021-06-23 at 17:25 -0500, Jerry LeVan wrote: > > So the question is: Why does using the short name evidently cause postresql > to use the ipv6 address > and using the full name use the ipv4 address? I'm thinking this might be coming from Avahi, which might be enabled on Fedora by default

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

2021-06-23 Thread Tom Lane
Jerry LeVan writes: > bigbox has a freshly installed Fedora 34 system and it runs postgresql 13.3 > the following are being run ON bigbox > nslookup bigbox returns the correct ipv4 address > nslookup bigbox.skynet returns the correct ipv4 address > psql -h bigbox.skynet allows me to connect to

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

2021-06-23 Thread Jerry LeVan
> On Jun 23, 2021, at 12:51 PM, Peter J. Holzer wrote: > > On 2021-06-21 19:44:16 -0500, 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:f6

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

2021-06-23 Thread Peter J. Holzer
On 2021-06-21 19:44:16 -0500, 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 This looks like a

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

2021-06-21 Thread Stephan Knauss
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

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

2021-06-21 Thread Tom Lane
Jerry Levan writes: > 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 This is mostly a matter of how your local DNS