Re: Bug #928: server_min_messages (log_min_messages in CVS) have

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: syatskevich(at)n21lab(dot)gosniias(dot)msk(dot)ru, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #928: server_min_messages (log_min_messages in CVS) have
Date: 2003-03-31 00:20:29
Message-ID: 200303310020.h2V0KTc21863@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers pgsql-patches

Tom Lane wrote:
> pgsql-bugs(at)postgresql(dot)org writes:
> > In src/backend/utils/misc/guc.c "server_min_messages"
> > ("log_min_messages" in CVS)configuration option have PGC_USERSET
> > GucContext. I think that it is not good idea that user can
> > change server log details level. I suggest change GucContext in
> > this case on PGC_SIGHUP.
>
> PGC_SUSET would be appropriate if we think that there's really a security
> issue here. But ISTM this was already considered when the present setup
> was designed, and we deliberately chose USERSET. Bruce, do you remember
> what the reasoning was?

The issue was that you might want to increase server logging in certain
clients to help debug a problem. If we had a "don't raise me" setting,
that would work.

Another idea is to add the ability to SET things perminantly.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Neil Conway 2003-03-31 05:55:08 Re: Bug #928: server_min_messages (log_min_messages in CVS)
Previous Message Tom Lane 2003-03-30 23:23:50 Re: Bug #928: server_min_messages (log_min_messages in CVS) have PGC_USERSET GucContext

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Yarra 2003-03-31 00:23:04 Re: ECPG thread-safety
Previous Message Tom Lane 2003-03-30 23:23:50 Re: Bug #928: server_min_messages (log_min_messages in CVS) have PGC_USERSET GucContext

Browse pgsql-patches by date

  From Date Subject
Next Message Philip Yarra 2003-03-31 00:23:04 Re: ECPG thread-safety
Previous Message Tom Lane 2003-03-30 23:23:50 Re: Bug #928: server_min_messages (log_min_messages in CVS) have PGC_USERSET GucContext