Re: entries in serverlog file

Hi Everybody,

I have read chapter 17 of the current manual and learned
interesting options. But as I compare what's in the
postgresql.conf file to what I think I comprehend, I am
a slightly confused:

In the conf file I see log_destination is set as 'stderr'
and redirect_stderr is set as off AND they are both commented
out. Yet, I am accumulating log entries into serverlog file.
To me this is a fine default setting. So my question amounts
to be the following:

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? I come from change-as-few-
things-as-possible-at-one-time-school.

Thank you in advance.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

-----Original Message-----
From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com]
Sent: Thu 8/9/2007 2:44 PM
To: Tena Sakai
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] entries in serverlog file

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tena Sakai wrote:
> Hi everybody,
>
> 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)?
>
> Thank you in advance.

http://www.postgresql.org/docs/current/interactive/runtime-config-logging.html

>
> Regards,
>
> Tena Sakai
> tsakai(at)gallo(dot)ucsf(dot)edu
>

- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGu4q7ATb/zqfZUUQRAgzrAJ9yatkzIfZgj7TxmhbaWigehhPVEQCfZoVO
n6Y80pi9LtTd9nvfd4rEeFw=
=zPj9
-----END PGP SIGNATURE-----