model-writtenrun 4426 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Peifeng Qiu proposed Kerberos delegation for libpq and postgres_fdw, storing delegated credentials in process-local memory instead of requiring a server-side keytab; the initial approach required a superuser to set password_required=false for the user mapping #1.
- Peifeng added gssencmode user-mapping support and TAP tests #2, and Peter Eisentraut requested reuse of src/test/kerberos, a combined code-and-tests patch, and investigation of dblink support #3.
- The submission stalled when Peifeng's address stopped working #5, then Stephen Frost took over in March 2022, rebasing the patch, consolidating the tests, and adding delegation state to connection logs #6.
- Jacob Champion questioned credential-handle cleanup, automatic delegation, and replacement of existing credential caches #7 #9; Stephen added handle release, PQconnectionUsedGSSAPI(), dblink integration, and explicit outbound-connection tests #10.
- Stephen introduced an HBA acceptance option and configurable backend credential-cache location, then added environment-preserving behavior and tests, but reported that the work had missed the PostgreSQL 15 deadline #11 #12.
- Robert Haas challenged the option naming, defaults, and cache-setting complexity #13; Stephen agreed to add a client-side delegation option disabled by default, which Robert endorsed #14 #15.
- Jacob investigated a deployment using GSS transport encryption with a separately protected foreign-server password and demonstrated that accepting client-delegated keys could expose that password; his independent Wireshark dissector patch provided the proof of concept and was not PostgreSQL implementation code #16 #17.
- Stephen disputed the deployment assumptions, and Jacob clarified that password authentication over the GSS-encrypted connection made the scenario distinct from passwordless impersonation; the unresolved discussion was subsequently marked returned with feedback #18 #19 #20.
- Stephen revived the work in February 2023 with explicit, default-disabled client and server controls, delegation reporting in pg_stat_gssapi, and expanded tests, replacing the earlier HBA and configurable-cache design #21.
- Stephen then strengthened dblink and postgres_fdw checks so non-superuser connections had to use supplied passwords or delegated GSS credentials, retained the explicit postgres_fdw password_required=false exception, and added tests against accidentally using environmental passwords #22.
- Greg Stark identified missing conditional compilation around GSS functions #23, and Stephen supplied two rounds of ENABLE_GSS fixes for builds without GSS support #24 #25.
- David Christensen reported successful testing and reviewed credential checks, GSS flags, documentation, and test coverage #26; Stephen added explicit delegation-flag validation, clarified descriptions, and removed debugging output #27.
- David's follow-up review prompted consistent delegated-credential terminology and GSS_C_NO_CREDENTIAL initialization; Stephen explained that constrained delegation remained a future enhancement #28 #29.
- David recommended separating the unrelated gssencmode user-mapping change and exposing gssdeleg there instead #30; Stephen made that substitution, and David marked the result ready for a committer #31 #32.
- After final wording and formatting cleanup #34, Stephen committed the attachment unchanged as 3d4fa227bc, crediting himself and Peifeng as authors and David as reviewer; the thread ends with the push confirmed and buildfarm monitoring beginning #35.