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

From Peter Korsgaard
Subject Re: How To Log User Name + Database?
Date
Msg-id Pine.GSO.4.21.0012062020550.28693-100000@brille.control.auc.dk
Whole thread Raw
In response to Re: How To Log User Name + Database?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, 6 Dec 2000, 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).

Not only that, but they would fill up almost all of the line (64+32 chars
max)

Perhaps you could write the data from the backendkeydata packet instead
(pid + secret) even though that would also take op quite some space
(atleast 8 + 8 chars)

--
Bye, Peter Korsgaard


pgsql-general by date:

Previous
From: John Pilley
Date:
Subject: Request for INSTALL help
Next
From: Chris Jones
Date:
Subject: Re: Questions from a Newbie