launchpad-dev team mailing list archive

[Stuart Bishop <stuart.bishop@xxxxxxxxxxxxx>]

On Fri, May 18, 2012 at 9:32 PM, Gary Poster <gary.poster@xxxxxxxxxxxxx> wrote:

> benji: not a trick yet: how do you get postgres logging from stored
> procedures (plpy.debug(“...”))?  where did it go?

In /etc/postgresql/9.1/main/postgresql.conf, there is a setting
'log_min_messages' that controls what level of messages get output to
the system log file. If you set this to 'debug1', your plpy.debug
messages will end up in /var/log/postgresql/postgresql-9.1-main.log. I
usually keep it at the default of 'warning' and use plpy.warn for
temporary stuff to keep the noise down.

http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html

-- 
Stuart Bishop <stuart.bishop@xxxxxxxxxxxxx>