From: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | connecting to localhost -> ::1 client_addr ? |
Date: | 2023-05-05 07:23:09 |
Message-ID: | CAKoxK+5wo8YVE7C2fCvz=UnSKEdtGfCpQKr2+B5mZhp_HHE_Sw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
this may be tribial, but I'm seeing connections from ::1 in
pg_stat_activity, and I've never realiuzed that psql converts
"localhost" in IPv6.
Is there a way to "force" the hostname localhost to appear as IPv4 or
am I missing something?
I've tested it also with a Perl program, and specifying localhost is
providing ::1 too. I suspect this is mainly due to the host name
resolution, but I'm not sure.
luca(at)venkman ~ % psql -h localhost -U luca -c 'SELECT
pid,usename,client_addr FROM pg_stat_activity
WHERE pid = pg_backend_pid();' testdb
pid | usename | client_addr
-----+---------+-------------
895 | luca | ::1
(1 row)
luca(at)venkman ~ % psql -h 127.0.0.1 -U luca -c 'SELECT
pid,usename,client_addr FROM pg_stat_activity
WHERE pid = pg_backend_pid();' testdb
pid | usename | client_addr
-----+---------+-------------
901 | luca | 127.0.0.1
(1 row)
luca(at)venkman ~ % psql -h venkman -U luca -c 'SELECT
pid,usename,client_addr FROM pg_stat_activity WH
ERE pid = pg_backend_pid();' testdb
pid | usename | client_addr
-----+---------+----------------
905 | luca | 192.168.222.13
(1 row)
luca(at)venkman ~ % psql 'user=luca host=localhost dbname=testdb' -c
'SELECT pid,usename,client_addr FR
OM pg_stat_activity WHERE pid = pg_backend_pid();'
pid | usename | client_addr
-----+---------+-------------
943 | luca | ::1
(1 row)
luca(at)venkman ~ % psql 'user=luca host=localhost dbname=testdb' -c
'SELECT version();'
version
----------------------------------------------------------------------------------------------------
------
PostgreSQL 14.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.2.1
20220127 (Red Hat 11.2.1-9), 6
4-bit
(1 row)
From | Date | Subject | |
---|---|---|---|
Next Message | Evgeny Morozov | 2023-05-05 07:50:32 | Re: "PANIC: could not open critical system index 2662" - twice |
Previous Message | Brainmue | 2023-05-05 04:55:39 | Re: RHEL repo package crc mismatches |