Re: entries in serverlog file

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: entries in serverlog file
Date: 2007-08-09 21:52:33
Message-ID: 46BB4651.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>>> On Thu, Aug 9, 2007 at 4:37 PM, in message
<FE44E0D7EAD2ED4BB2165071DB8E328C03062B24(at)egcrc-ex01(dot)egcrc(dot)org>, "Tena Sakai"
<tsakai(at)gallo(dot)ucsf(dot)edu> wrote:
> I have, by default, on a linux machine, a file called
> serverlog in the data directory, whose entries often
> prove to be very useful. What would be even more useful
> would be a timestamp along with each entry.
>
> Is there any way I can add such timestamp at this point?
> Perhaps via postgresql.conf file (also in the data directory)?

By all means, do read the documentation referred to by Joshua.

For a quick starting point, we have found it useful to use
these settings:

redirect_stderr = on
log_line_prefix = '[%m] %p %q<%u %d %r> '

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tena Sakai 2007-08-09 23:20:18 Re: entries in serverlog file
Previous Message Joshua D. Drake 2007-08-09 21:44:27 Re: entries in serverlog file