From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Tena Sakai <tsakai@gallo.ucsf.edu>
To: pgsql-admin@postgresql.org
Subject: Re: entries in serverlog file
Date: Thu, 09 Aug 2007 16:52:33 -0500
Message-ID: <46BB4651.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C03062B24@egcrc-ex01.egcrc.org>
References: <FE44E0D7EAD2ED4BB2165071DB8E328C03062B24@egcrc-ex01.egcrc.org>
>>> On Thu, Aug 9, 2007 at 4:37 PM, in message
<FE44E0D7EAD2ED4BB2165071DB8E328C03062B24@egcrc-ex01.egcrc.org>, "Tena Sakai"
<tsakai@gallo.ucsf.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> '
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, tsakai@gallo.ucsf.edu
Subject: Re: entries in serverlog file
In-Reply-To: <46BB4651.EE98.0025.0@wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox