
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.




Mon, 4 Jan 1999 18:14:57 +0200 (EET)
Blashko Alexander <black@lins.ospu.odessa.ua>
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  |
+----------------------------------------------------------------------+

Mon, 4 Jan 1999 18:36:57 +0100 (MET)
Massimo Dal Zotto <dz@cs.unitn.it>
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  |
> +----------------------------------------------------------------------+
> 


Tue, 5 Jan 1999 10:10:07 +0200 (EET)
Blashko Alexander <black@lins.ospu.odessa.ua>
Re: pg_options ?