From: | Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com> |
---|---|
To: | PostgreSQL Mailing List <pgsql-admin(at)postgresql(dot)org> |
Subject: | Logging RAISE statement to a logfile aside from syslog |
Date: | 2002-11-04 06:29:30 |
Message-ID: | 20021104062930.80372.qmail@web80309.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | dima | 2002-11-04 13:32:38 | dumping a password-protected db from a perl script or a binary |
Previous Message | Naomi Walker | 2002-11-03 23:41:54 | Re: loading and unloading rows |