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.