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 [EMAIL PROTECTED] -----Original Message----- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] Sent: Thu 8/9/2007 2:44 PM To: Tena Sakai Cc: pgsql-admin@postgresql.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 > [EMAIL PROTECTED] > - -- === 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-----