model-writtenrun 8168 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Nathan Bossart opened the thread with three patches to centralize client password-buffer sizes, document inconsistent restrictions, and increase the server's password-packet limit to 8192 bytes #1.
- Stephen Frost requested consistent client/server limits and tests, while Isaac Morland and Tom Lane favored relatively short common limits; Stephen also opposed breaking existing long passwords and suggested allocating larger buffers dynamically #2 #3 #5 #7 #8.
- Nathan justified longer passwords with generated security tokens, and Alexander Kukushkin supplied a concrete case involving 600–700-byte JWTs that password prompts and .pgpass could not accommodate #12 #13.
- Nearly two years later, Tom revived the work with a common 1024-byte limit and long-password tests, dropping the repetitive SGML documentation in favor of a comment in pg_config_manual.h; he subsequently reported that the separate .pgpass prerequisite had landed #14 #15.
- Nathan explained that deployed tokens already exceeded 1024 bytes, and Peter Eisentraut proposed accepting whatever StringInfo could hold instead of choosing another fixed limit #16 #17.
- Tom implemented dynamic simple_prompt() results, moved sprompt.c into src/common/, and removed the packet and SASLprep limits, then simplified password-state tracking and corrected the Windows build entry in the next version #19 #20.
- Nathan's review identified an 8192-byte limit still present in initdb's password-file reader; Tom initially considered documenting that exception, and Nathan accepted that compromise #21 #22 #23.
- After mentioning a related proposal for a reusable line reader, Tom ended the thread by deciding to extract simple_prompt()'s input-reading logic into a dynamically allocating function that initdb could also use #24 #25.
- Tom then committed 67a472d71c from #20 with the additional pg_get_line() refactoring and initdb conversion, completing the password-limit work while leaving broader adoption of the new line reader for future patches.