Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r7Dfu-004bsH-FC for pgsql-general@arkaria.postgresql.org; Sun, 26 Nov 2023 11:51:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r7Dfs-0086Na-Fv for pgsql-general@arkaria.postgresql.org; Sun, 26 Nov 2023 11:51:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r7Dfs-0086NS-3h for pgsql-general@lists.postgresql.org; Sun, 26 Nov 2023 11:51:44 +0000 Received: from mail.hjp.at ([212.17.106.138] helo=rorschach.hjp.at) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r7Dfl-007RGa-CY for pgsql-general@lists.postgresql.org; Sun, 26 Nov 2023 11:51:42 +0000 Received: by rorschach.hjp.at (Postfix, from userid 1000) id B7D7E11F5B; Sun, 26 Nov 2023 12:51:34 +0100 (CET) Date: Sun, 26 Nov 2023 12:51:34 +0100 From: "Peter J. Holzer" To: pgsql-general@lists.postgresql.org Subject: Re: pg_getnameinfo_all() failed: Temporary failure in name resolution Message-ID: <20231126115134.htanqdchbmn4z2ic@hjp.at> Mail-Followup-To: pgsql-general@lists.postgresql.org References: <7e79132a-0879-4382-823e-5a6b16d99dac@aklaver.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="7lotajmuzbo2vnms" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --7lotajmuzbo2vnms Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On 2023-11-24 16:39:57 -0500, Ron Johnson wrote: > On Fri, Nov 24, 2023 at 4:26=E2=80=AFPM David G. Johnston > wrote: >=20 > On Friday, November 24, 2023, Ron Johnson w= rote: >=20 >=20 > The second "way" sounds interesting, but what is it filled with? With "???" (which isn't very helpful. I would have hoped it's filled in with a representation of the IP address) > What does it matter?=C2=A0 It=E2=80=99s an internal detail that appar= ently gets exposed > as [unknown] appearing in your log file where the client ip address w= ould > normally be. >=20 >=20 > Because I'd hope that the log file would tell me the errant host name.=C2= =A0=C2=A0 The error message says that the host name could not be determined because of a DNS error. So obviously it can't tell you the host name. It could tell you the IP address, though. > I added "log_hostname =3D on" to postgresql.conf earlier in the d= ay.=C2=A0 > When I commented that out, the errors stopped happening. >=20 >=20 > This makes sense. >=20 >=20 > But is not explanatory.=C2=A0 I want to see host names in the log file wh= en > possible, not just IP addresses. So now that you have IP addresses again, are there any for which a reverse lookup doesn't work? hp --=20 _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@hjp.at | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!" --7lotajmuzbo2vnms Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmVjMUEACgkQ8g5IURL+ KF3ObRAArkTDOE0huZouyKJA4ssPuFWnmPPsrs5xW5qPg+IZ00ldDEhso7zxGEwF n8rK4SpOVzGENofEGE0oWfFU55JZMo5Sq4/LuocV7UM5ooatWSSWfJaYkfMuiKVg ss/nvhoid4BE2VcAE0quW4bR4CpRaR60a6fZyryZtfEGzb5L8+19szUYbqslyT6Z 0930mxj16xFuwDcHeVy/kUuQ52VkXH1BvTpbXE9uQQlyQiDuJUE8swkoDVnbTUWV tNm94l2Z/EKQEVNemvcM7n2QnVNM+mW0spAP9so4UlBBGuOegtQ5fUdlZVlAcx0A R+nksTcyhjSd9VvOJmyo1tKSjNam/aHN7/ynwU05FY3Xe0Bz1M/Ghb1gKAepMeCn 0onoUiScF0lqQXtez2DDdmhTQWmiunLxgJc2L3wm+vNZDA1HQ9GDEdpR+/pxAezt tesFUznXtqpVVl8Dexb7fsaUpBshkRRd9A0ZLE6xVm1u5viL3i45Vk91CHl4Ouj7 Y8/gQyjSgfMOf+LjHOrZL2oGYqVPZKepbe1J8D5x3xjYw8J6J2fyz//GwdxZh4XE I+pFDe61JrVSQ3IzNUKGI9ESXxFv3RhPN8ZttFLO/guv7yvdIOmJS77YQqMR+BTp 2yPgKvJrCnwoWq0d6qqgxU65ABBB7QOQCDJ3jj/DjMw1pe/CDSA= =qTqg -----END PGP SIGNATURE----- --7lotajmuzbo2vnms--