From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tena Sakai <tsakai@gallo.ucsf.edu>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: entries in serverlog file
Date: Mon, 13 Aug 2007 15:42:29 -0400
Message-ID: <20245.1187034149@sss.pgh.pa.us> (raw)
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C03062B32@egcrc-ex01.egcrc.org>
References: <FE44E0D7EAD2ED4BB2165071DB8E328C03062B24@egcrc-ex01.egcrc.org>
<46BB8ABB.8090503@commandprompt.com>
<FE44E0D7EAD2ED4BB2165071DB8E328C03062B32@egcrc-ex01.egcrc.org>
"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
> Can I just uncomment log_line_prefix entry and stick what I want
> (such as %u, %d, %m, etc) into the quotes and expect to see the
> logged lines be prefixed with username, database name, timestamp,
> etc with all other things intact?
Sure; you will however regret by and by that you didn't turn on
redirect_stderr, because there is no way to rotate the logfile
(other than restarting the postmaster) when it's simply going straight
to stderr. The more verbose you make the log, the sooner its bulk is
going to become a problem...
regards, tom lane
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: tgl@sss.pgh.pa.us, tsakai@gallo.ucsf.edu, jd@commandprompt.com
Subject: Re: entries in serverlog file
In-Reply-To: <20245.1187034149@sss.pgh.pa.us>
* 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