The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/runtime-config-client.html Description:
It took me a good bit of searching to find the page for remembering that client_min_messages was the variable for the debug level. I think my basic stumbling block was that the syntax for RAISE uses DEBUG as the keyword, but "message level" is the term used elsewhere; so, I was looking for how to set the debug level rather than the message level. I'd just forgotten the lingo, but knew I'd changed it a long time ago in a galaxy far away, and would find it eventually. I'd searched for 'debug' and got these results: https://www.postgresql.org/search/?u=%2Fdocs%2F10%2F&q=DEBUG I also searched for 'debug-level' and get even fewer results: https://www.postgresql.org/search/?u=%2Fdocs%2F10%2F&q=debug-level Trying 'debug set' gets https://www.postgresql.org/search/?u=%2Fdocs%2F15%2F&q=DEBUG+set The result that looks most promising for 'debug' (and the only result for 'debug-level' is > 9. PostgreSQL: Documentation: 10: postgres [0.02] > ...debug-level Sets the debug level. The higher this value is set, the more debugging... > https://www.postgresql.org/docs/10/app-postgres.html and the app-postgres.html page indeed says "-d debug-level Sets the debug level..." A Google search finally got me to: https://www.google.com/search?q=postgres+set+debug-level&rlz=1C5GCEM_enUS1015US1016&oq=postgres+set+debug-level&aqs=chrome..69i57j0i22i30l2j69i64.5046j0j4&sourceid=chrome&ie=UTF-8 Google made it easy (doh!) but I'd been staying in the postgres.org ecosystem and using the internal search. So, a couple of suggestions: - I think that on https://www.postgresql.org/docs/15/app-postgres.html, under the `-d` description, it would be helpful to include a link to https://www.postgresql.org/docs/10/runtime-config-logging.html#GUC-LOG-MIN-MESSAGES and perhaps https://www.postgresql.org/docs/10/runtime-config-client.html#GUC-CLIENT-MIN-MESSAGES as ways to override the value initially specified by -d (disclaimer: I don't know if '-d' can be overwritten; I don't run postgres servers) - Perhaps under client_min_messages on https://www.postgresql.org/docs/10/runtime-config-client.html#GUC-CLIENT-MIN-MESSAGES make a reference something "this sets the debug level for the current session" - Perhaps under log_min_messages on https://www.postgresql.org/docs/10/runtime-config-logging.html#GUC-LOG-MIN-MESSAGES a similar statement that "this is a [distinct | related | overriding] setting for the '-d debug-level' when [starting Postgres](https://www.postgresql.org/docs/15/app-postgres.html)" - The page https://www.postgresql.org/docs/11/plpgsql-errors-and-messages.html has links to both 'client_min_messages' and 'log_min_messages' and it's probably my fault for skimming the page too fast. It still strikes me odd, though, that searching for 'set DEBUG level' doesn't pop this page to the top, but lets it sit down at #10 with a relevance(?) of [0.00] Some of these ideas may be better suited for a "Note" box on the page; basically, having some way to improve the search results to bring these pages to the top is the central concern here.... and I had found it personally frustrating enough to take the time to write this tome :- )
