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

When I couldn't even get my own newly added printfs to show up, that was the
tipoff. Redhat 6.1 installs postmaster in /bin. I didn't know it, and have
been building/installing elsewhere. /bin, of course, is first in my PATH,
before *my* pgsql install bin. Ouch. Timestamping is now working. Thanks
much for your efforts.

Cheers,
Ed Loehr

"Culberson, Philip" wrote:

> Ed,
>
> Configure will used cached values if config.cache is available so you may
> consider first doing a "make distclean", which is the mother of all
> cleanouts. Then do the ./configure, 'make', and 'make install'.
>
> I have not yet configure SYSLOG for use, so I redirect all output from the
> postmaster into a file with the following command:
>
> exec postmaster -i -B 12000 -d 2 -o "-F -S 4096 -s" >&! server.log &
>
> Phil Culberson
>
> -----Original Message-----
> From: Ed Loehr [mailto:ELOEHR(at)austin(dot)rr(dot)com]
> Sent: Friday, December 17, 1999 2:21 PM
> To: Culberson, Philip
> Cc: 'pgsql-general(at)postgreSQL(dot)org'
> Subject: Re: [GENERAL] How to get timestamped pgsql logging?
>
> Thanks, Phil. Still, the good mojo escapes me. Time to cut my losses.
>
> I commented USE_SYSLOG back out, then twiddled elog.h, twiddled config.h
> after
> ./configure (configure builds a new config.h), tried a few variation on
> pg_options, all while bringing down postmaster, running 'make clean',
> 'make',
> 'make install', and restarting on each try. I rebuilt with printf's in the
> trace.c functions near the code segments using ELOG_TIMESTAMPS, but am not
> even seeing that output...I can see the new libpq.so...*that* concerns me.
> LD_LIBRARY_PATH is set correctly.
>
> Latest incantation of pg_options is:
>
> verbose=2
> query
>
> Also tried...
>
> all
> verbose=2
> query
>
> Cheers,
> Ed Loehr
>
> "Culberson, Philip" wrote:
>
> > Oh, one more thing. I've always made the edit BEFORE running ./configure.
> >
> > Phil Culberson
> >
> > -----Original Message-----
> > From: Culberson, Philip
> > Sent: Friday, December 17, 1999 11:42 AM
> > To: 'Ed Loehr'; pgsql-general(at)postgreSQL(dot)org
> > Subject: 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
> >
> > ************
>
> ************
>
> ************