Обсуждение: pg_options ?

Поиск
Список
Период
Сортировка

pg_options ?

От
Blashko Alexander
Дата:
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.