Re: pg_options ?

On Mon, 4 Jan 1999, Massimo Dal Zotto wrote:

> > 
> > 
> > Hi everybody.
> > I tried to use pg_options for monitoring sql-query.
> > pg_options: all=1
> > /ets/syslog.conf:
> >   local5.*     /var/log/postgres
> > for postgres start i use script src/contrib/linux/postgres.init.csh:
> > (postmaster -d 2  2>&1 | logger -p local5.notice) &
> > 
> > In /var/log/postgres i have:
> > Jan  4 17:13:09 SantaMariya logger: StartTransactionCommand
> >  
> > 
> > How can i give syslog information in form:
> > #timestamp          #pid    #message
> > 
> > For example:
> > Jan  4 17:13:09.173 [29271] StartTransactionCommand
> >                 ^^^  ^^^^^
> >                 I need this 
> >                 information.
> > 
> > Thank you for your answer.
> 
> There is a better way to do it. Compile postgres with -DUSE_SYSLOG, add
> syslog=1 or syslog=2 into pg_options and it will output all elog messages
> to the syslog facility with the pid. See trace.c for details.
> But you won't be able to see the milliseconds fields because syslog
> doesn't handle this information.

Thank you for your answer.
But in doc (pg-options.html) you got example:
#timestamp          #pid    #message
980127.17:52:14.173 [29271] StartTransactionCommand
980127.17:52:14.174 [29271] ProcessUtility: drop table t;
980127.17:52:14.186 [29271] SIIncNumEntries: table is 70% full

How can i get this information with milliseconds without using syslog ?               
Thank you for your answer.
> 
> -- 
> Massimo Dal Zotto
> 
> +----------------------------------------------------------------------+
> |  Massimo Dal Zotto               email: dz@cs.unitn.it               |
> |  Via Marconi, 141                phone: ++39-0461534251              |
> |  38057 Pergine Valsugana (TN)      www: http://www.cs.unitn.it/~dz/  |
> |  Italy                             pgp: finger dz@tango.cs.unitn.it  |
> +----------------------------------------------------------------------+
>