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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [ADMIN] Re: [HACKERS] RFC: Industrial-strength logging (longmessage)
Дата
Msg-id 199910260527.BAA21909@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [ADMIN] Re: [HACKERS] RFC: Industrial-strength logging (longmessage)  (Tim Holloway <mtsinc@southeast.net>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Function-manager redesign: second draft (long)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Logging - pg_options format change?