Hi Joshua,
Hi Kevin,
Many thanks for your suggestions/advices.
I am reading chapter 17 of the manual, which in the hindsight,
I should have read a month ago. But this is very good. I am
making haste slowly.
Thanks again.
Regards,
Tena Sakai
tsakai@xxxxxxxxxxxxxx
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>From Kevin Grittner [Kevin.Grittner@xxxxxxxxxxxx]
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> '
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-----Original Message-----
From: Joshua D. Drake [mailto:jd@xxxxxxxxxxxxxxxxx]
Sent: Thu 8/9/2007 2:44 PM
To: Tena Sakai
Cc: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: 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@xxxxxxxxxxxxxx
>
- --
=== 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-----
