Re: pg_getnameinfo_all() failed: Temporary failure in name resolution - Mailing list pgsql-general

From Ron Johnson
Subject Re: pg_getnameinfo_all() failed: Temporary failure in name resolution
Date
Msg-id CANzqJaBP7mD0Z35A7T2UO+MiAH4wWXWrb1bpU0qrVj1Z3gvzRQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_getnameinfo_all() failed: Temporary failure in name resolution  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: pg_getnameinfo_all() failed: Temporary failure in name resolution  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
On Fri, Nov 24, 2023 at 4:26 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Friday, November 24, 2023, Ron Johnson <ronljohnsonjr@gmail.com> wrote:

The second "way" sounds interesting, but what is it filled with?

What does it matter?  It’s an internal detail that apparently gets exposed as [unknown] appearing in your log file where the client ip address would normally be.

Because I'd hope that the log file would tell me the errant host name.  
 

I added "log_hostname = on" to postgresql.conf earlier in the day.  When I commented that out, the errors stopped happening.

This makes sense.

But is not explanatory.  I want to see host names in the log file when possible, not just IP addresses.

In pg_hba.conf. all application servers are either IP addresses, or names that are explicitly defined in /etc/hosts.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: replication primary writting infinite number of WAL files
Next
From: Les
Date:
Subject: Re: replication primary writting infinite number of WAL files