Обсуждение: adding timestamp to log file entries?

Поиск
Список
Период
Сортировка

adding timestamp to log file entries?

От
James Hartley
Дата:
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

Re: adding timestamp to log file entries?

От
"mark"
Дата:
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


Re: adding timestamp to log file entries?

От
James Hartley
Дата:
On Thu, Sep 1, 2011 at 6:43 PM, mark <dvlhntr@gmail.com> wrote:
Jim wrote...

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.

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