On Fri, May 18, 2012 at 9:32 PM, Gary Poster <gary.pos...@canonical.com> 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.bis...@canonical.com> _______________________________________________ Mailing list: https://launchpad.net/~launchpad-dev Post to : launchpad-dev@lists.launchpad.net Unsubscribe : https://launchpad.net/~launchpad-dev More help : https://help.launchpad.net/ListHelp
