Re: [ADMIN] Re: [HACKERS] RFC: Industrial-strength logging (longmessage) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [ADMIN] Re: [HACKERS] RFC: Industrial-strength logging (longmessage)
Date
Msg-id 199910260527.BAA21909@candle.pha.pa.us
Whole thread Raw
In response to Re: [ADMIN] Re: [HACKERS] RFC: Industrial-strength logging (longmessage)  (Tim Holloway <mtsinc@southeast.net>)
List pgsql-hackers
> 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.

One more item I have not heard is that you can create virtual table that
look like tables but return data about users, queries on SELECT.

Informix does this.  Allows you to get info, without the need for
storage.  Not good for every case, but an interesting idea sometimes.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Function-manager redesign: second draft (long)
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Logging - pg_options format change?