Re: How To Log User Name + Database? - Mailing list pgsql-general

From Ed Loehr
Subject Re: How To Log User Name + Database?
Date
Msg-id 3A2E8640.60821E52@austin.rr.com
Whole thread Raw
In response to How To Log User Name + Database?  (Ed Loehr <eloehr@austin.rr.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: How To Log User Name + Database?
Next
From: Peter Eisentraut
Date:
Subject: Re: How To Log User Name + Database?