From: "Edward J. Sabol" <edwardjsabol@gmail.com>
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 11.5 \(3445.9.7\))
Date: Mon, 16 Nov 2020 15:12:13 -0500
Subject: pg_stat_activity's client_addr column contains "::1" but actually
 comes from elsewhere?
Message-Id: <371E399B-8751-4A50-890D-02F899581EB6@gmail.com>
To: pgsql-admin@postgresql.org
Precedence: bulk

Hello! I'm trying to track down where some connections are coming from. =
"select pid,client_addr,client_hostname from pg_stat_activity" shows =
multiple entries with values with client_addr =3D "::1". =
"client_hostname" is blank for all entries, by the way, and unhelpful in =
this scenario. Also, "state" is "idle" for these entries I'm interested =
in, in case that matters.

::1 would imply the IPv6 loopback address, so that means the connection =
is coming from a process on the server, right? But I'm positive there is =
no process on this server that is connecting to PostgreSQL (other than =
my psql session).

So where are they actually coming from and why is PostgreSQL seemingly =
misreporting them as coming from ::1?

Thanks for any help,
Ed