From: | Blashko Alexander <black(at)lins(dot)ospu(dot)odessa(dot)ua> |
---|---|
To: | dz(at)cs(dot)unitn(dot)it |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | pg_options ? |
Date: | 1999-01-04 16:14:57 |
Message-ID: | Pine.LNX.3.96.990104175104.2250A-100000@lins.ospu.odessa.ua |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Jun Zhang | 1999-01-04 16:45:22 | Failed to compile |
Previous Message | Giuliano A. Tarallo | 1999-01-03 11:36:44 | subscribe pgsql-general |
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1999-01-04 16:29:03 | Re: [HACKERS] SQLJ |
Previous Message | Vazsonyi Peter[ke] | 1999-01-04 16:06:15 | Q: Log, via triggers |