Re: How To Log User Name + Database?

Поиск
Список
Период
Сортировка
От Ed Loehr
Тема Re: How To Log User Name + Database?
Дата
Msg-id 3A2E8640.60821E52@austin.rr.com
обсуждение исходный текст
Ответ на How To Log User Name + Database?  (Ed Loehr <eloehr@austin.rr.com>)
Список pgsql-general
Tom Lane wrote:
>
> Ed Loehr <eloehr@austin.rr.com> writes:
> > Would it be better to
> > (optionally) allow the db name and user name to be logged on each
> > line?
>
> That would bulk up the log considerably, and also create formatting
> problems (you couldn't really make these items be fixed-width columns).

These points, at least the first, suggest to me it should be an optional
feature.  But regarding bulkier logs, FWIW, I would gladly trade the
time/hassle of correlating visually correlating log entries for
additional disk space.  Time is far more expensive than disk space.
Regarding fixed width problems, not sure why fixed-width columns would be
a requirement.  I'll assume it is some unusual internal pg formatting
constraint.  Apache and others obviously handle variable width logging...

Regards,
Ed Loehr

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How To Log User Name + Database?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: How To Log User Name + Database?