Tom Lane wrote:
> There's some value in being able to kick the log level up a notch for
> a specific session, but knocking it down from the admin's default could
> be considered a bad thing. I suppose we could invent a PGC_SIGHUP
> "min_server_min_messages" variable that sets a minimum value below which
> the user can't set server_min_messages. Does that seem like a good
> idea, or overkill?
>
> A compromise position would be to make these two variables PG_SUSET,
> ie settable per-session but only if you're superuser.
Oh, I just saw your compromise position. Yes, I think that is the way
to go.
In fact, aside from the security issue, allowing users to throw
voluminous debug info into the server logs doesn't seem like a good idea
anyway.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073