You need only ELOG_TIMESTAMPS defined. syslogd is another story -
I had no luck with it under Linux. Don't forget to make clean and
recompile sources. It should works.
Oleg
On Fri, 17 Dec 1999, Ed Loehr wrote:
> Date: Fri, 17 Dec 1999 02:06:08 -0600
> From: Ed Loehr <ELOEHR@austin.rr.com>
> To: Tom Lane <tgl@sss.pgh.pa.us>
> Cc: Matthew Hagerty <matthew@venux.net>, pgsql-hackers@postgreSQL.org
> Subject: Re: [HACKERS] Postmaster options, process spawning, logging, etc.
>
> Tom Lane wrote:
>
> > > The postmaster log file, why are the entries not datestamped?
> >
> > Uncomment #define ELOG_TIMESTAMPS in include/config.h after configure
> > and before make...
>
> I'm still missing something...
>
> After running ./configure, I modifed ...src/include/config.h to uncomment
> this...
>
> #define ELOG_TIMESTAMPS
>
> [I also came back later and tried uncommenting #define USE_SYSLOG and repeating
> the process, but to no avail...]
>
> 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
>
> [ps - Forgive my spewage...I mistakenly sent this out of context to
> pgsql-general as well...]
>
>
> ************
>
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83