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

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.