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(at)cs(dot)unitn(dot)it |
> | Via Marconi, 141 phone: ++39-0461534251 |
> | 38057 Pergine Valsugana (TN) www: http://www.cs.unitn.it/~dz/ |
> | Italy pgp: finger dz(at)tango(dot)cs(dot)unitn(dot)it |
> +----------------------------------------------------------------------+
>