Thread

1. pg_options ?

   Blashko Alexander <black@lins.ospu.odessa.ua> — 1999-01-04T16:14:57Z

   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.
   
   
   
   
   

2. Re: pg_options ?

   Massimo Dal Zotto <dz@cs.unitn.it> — 1999-01-04T17:36:57Z

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

3. Re: pg_options ?

   Blashko Alexander <black@lins.ospu.odessa.ua> — 1999-01-05T08:10:07Z

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