RE: [GENERAL] How to get timestamped pgsql logging?

Ed,

My own notes on how to get timestamped error logs refer to the file
"...src/include/utils/elog.h". There is a commented out "#define
ELOG_TIMESTAMPS" line in that header as well. Since version 6.4, I have
always uncommented THAT line and I get timestamps in my error logs... can't
tell you why it doesn't work by doing it in the config.h file...

(I am currently using version 6.5.2, so it may have changed in the most
recent version.)

Hope this helps!

Phil Culberson

-----Original Message-----
From: Ed Loehr [mailto:ELOEHR(at)austin(dot)rr(dot)com]
Sent: Thursday, December 16, 1999 11:59 PM
To: pgsql-general(at)postgreSQL(dot)org
Subject: [GENERAL] How to get timestamped pgsql logging?

After following some hints from Bruce Momjian and the pgsql documentation,
I'm still missing something on how to get timestamped backend logging from
pgsql...any help is appreciated...

After running ./configure, I modifed ...src/include/config.h to uncomment
the two lines...

#define ELOG_TIMESTAMPS
#define USE_SYSLOG

Then I ran make, etc, created the file $PGDATA/pg_options...

% cat $PGDATA/pg_options
verbose=2
query
syslog=2

And restarted the server...and still no timestamps.

I verified most everything syslog-wise (configured in /etc/syslog.conf) is
being sent to /var/log/messages...

Anyone notice what am I missing?

Cheers,
Ed Loehr

************