Logging RAISE statement to a logfile aside from syslog
От | Ludwig Lim |
---|---|
Тема | Logging RAISE statement to a logfile aside from syslog |
Дата | |
Msg-id | 20021104062930.80372.qmail@web80309.mail.yahoo.com обсуждение исходный текст |
Ответы |
Re: Logging RAISE statement to a logfile aside from syslog
|
Список | pgsql-admin |
Hi: Is there a way of logging the RAISE statements in a plpgsql function to a logfile (aside from syslog)? I noticed that all RAISE statments are only logged in the syslog. The following is a portion my current configuration related to logging: log_connection = true log_timestamp = true debug_level = 3 syslog = 2 syslog_facility = 'LOCAL0' syslog_ident = 'postgres' I did not raise the log level to 4 since it create large volumes of logfile. The following is the portion of the script that start my postgresql daemon at boot in /etc/rc.d/init.d : start() { su postgres -c "/usr/local/pgsql/bin/pg_ctl start -l /var/log/postgres/postgres.log -D /data 2> /var/log/postgres/postgres.log" } - I noticed that postgres.log does not contain anything when the debug level is at 3. Version : PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC 2.96 Platform : Redhat 7.1 Thank you in advance, ludwig __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com
В списке pgsql-admin по дате отправления: