On Fri, May 18, 2012 at 9:32 PM, Gary Poster <[email protected]> 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 <[email protected]>

_______________________________________________
Mailing list: https://launchpad.net/~launchpad-dev
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~launchpad-dev
More help   : https://help.launchpad.net/ListHelp

Reply via email to