Re: How To Log User Name + Database?

From: Peter Korsgaard <jacmet(at)control(dot)auc(dot)dk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pggeneral <pgsql-general(at)postgresql(dot)org>
Subject: Re: How To Log User Name + Database?
Date: 2000-12-06 19:35:52
Message-ID: Pine.GSO.4.21.0012062020550.28693-100000@brille.control.auc.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 6 Dec 2000, Tom Lane wrote:

> Ed Loehr <eloehr(at)austin(dot)rr(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ed Loehr 2000-12-06 19:58:17 Re: How To Log User Name + Database?
Previous Message Nathan Myers 2000-12-06 19:18:56 CRCs (was: beta testing version)