Re: pg_options ?

>
>
> 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.

--
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 |
+----------------------------------------------------------------------+