From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
Cc: | rsindlin(at)gmail(dot)com |
Subject: | Information on setting the message level is too hard to find if you search for "debug" |
Date: | 2023-04-20 17:08:05 |
Message-ID: | 168201048588.2127921.4364221899511300364@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
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 :- )
From | Date | Subject | |
---|---|---|---|
Next Message | Jelte Fennema | 2023-04-20 17:14:27 | Re: documentation for PGLOADBALANCEHOSTS environment variable in libpq |
Previous Message | Fujii Masao | 2023-04-20 15:49:06 | documentation for PGLOADBALANCEHOSTS environment variable in libpq |