model-writtenrun 9864 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Albert Schabhuetl reported that PAM authentication over Unix-domain sockets caused DNS queries for the symbolic hostname "[local]", potentially delaying authentication #1; Thomas Munro traced those queries to Linux PAM's libaudit integration #2.
- Thomas Munro favored leaving PAM_RHOST unset over using the local machine's hostname, preserving the distinction between Unix-socket and IP connections #3; Albert Schabhuetl also advocated NULL when pam_use_hostname was disabled #4.
- Thomas Munro clarified that TCP connections still supply an address or hostname and posted a patch limited to skipping PAM_RHOST for Unix sockets, with manual test results demonstrating the resulting empty value #5.
- Peter Eisentraut requested also avoiding pg_getnameinfo_all() for local connections #6, and Thomas Munro revised the patch to place both operations under one guard and simplify the flags expression #7.
- Thomas Munro considered an automated PAM authentication test but explained that both open-source PAM implementations' reliance on configuration under /etc made it difficult; no automated test accompanied the revised patch #7.
- The revised patch #7 landed unchanged as 0f9cdd7dca, and Thomas Munro closed the thread by confirming backpatching through PostgreSQL 9.6 and explaining that a release note sufficed because the old "[local]" value had never been documented #8.