Thread: adding timestamp to log file entries?

I looked through the 9.0 Manual on the PostgreSQL Website, but didn't find this covered.  I may not have known what to look for.  I would like to add timestamps to the entries made to PostgreSQL's log file.  I vaguely recall that this was configurable in the 8.x literature, but can't find the specifics.  Can anyone shed any information?

Thanks.

Jim

Jim wrote...

>I looked through the 9.0 Manual on the PostgreSQL Website, but didn't find
this covered.  I may not have known what to look for.  I would like to >add
timestamps to the entries made to PostgreSQL's log file.  I vaguely recall
that this was configurable in the 8.x literature, but can't find the
>specifics.  Can anyone shed any information?

>Thanks.

>Jim




http://www.postgresql.org/docs/9.0/static/runtime-config-logging.html

I *think* what you want is %t in your log_line_prefix


-Mark

This is exactly what I needed & didn't see.  Thank you!  I needed the cluestick.

Jim