Re: [ADMIN] Re: [HACKERS] RFC: Industrial-strength logging (longmessage)

Why not do something similar to what we are doing with pg_shadow?  If I
remember the logic right, when you update pg_shadow, one ofits "steps" is
to dump it to a text file so that postmaster can read it?  this should
make it easy for one user/database to have one logging set, while another
doesn' have it set at all...and should make it so that each database
*should* theoretically log to different files/mechanisms?

On Sat, 23 Oct 1999, Tim Holloway wrote:

> 
> 
> The Hermit Hacker wrote:
> > 
> > On Sat, 23 Oct 1999, Aaron J. Seigo wrote:
> > 
> > > > There MUST exist a way to alter the logging level on-the-fly;
> > > > IMHO this is a rock bottom, non negotiable requirement.
> > >
> > > whilst i don't think this is MUST, it is EXTREMELY desirable and would make the
> > > logging actually useful for large installations =)
> > 
> > Let's re-iterate Tom here: There MUST exist a way ... someone *MUST* be
> > able to change their configuration without having to physically stop/start
> > the server to affect the changes ...
> > 
> > Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
> > Systems Administrator @ hub.org
> > primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org
> 
> I think we have a consensus. Destroy and recreate logging
> data structures/tasks on receipt of
> suitable event.
> 
> For simple things like log levels, though, I'd still like
> feedback on
> desirablility and feasibility of altering basic logging
> options though
> (authorized!) frontends. As a user, I get nervous when I
> have to thread
> my way past possibly-fragile unrelated items in a config
> file when I'm trying
> to do a panic diagnosis. As an administrator, I get even
> MORE nervous if one
> of the less careful people I know were to be entrusted with
> that task.
> 
> Another possible mode of controlling what's logged is to
> assign mask bits to various
> classes of messaages and allow the administrator to alter
> the filter mask.
> Although, in truth, the channel design is pretty much the
> same thing.
> 
>     Tim Holloway
> 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org