Hi Tom,
Thanks. I will live a bit dangerously while I
strategize what to do with the logfile. I am
not sure if 7 day log rotation is really a
wise option for now. I will come up with
something fitting in time. Thanks for your
comment, nonetheless.
Regards,
Tena Sakai
tsakai@gallo.ucsf.edu
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Mon 8/13/2007 12:42 PM
To: Tena Sakai
Cc: Joshua D. Drake; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] entries in serverlog file
"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