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