"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
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
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
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
> 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
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
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
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
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
hostall all 192.168.1.0/24 trust
I modif
