debug levels in server

Started by David Parkeralmost 21 years ago2 messagesgeneral
Jump to latest
#1David Parker
dparker@tazznetworks.com

I'm trying to track down a hang in a slony "lock set" command, which
creates triggers on a set of tables. I assume that it's getting blocked
by a lock on a table somewhere, and I'd like to print out all the
"create trigger" statements in the postgres log.

I have log_min_messages = DEBUG5, and I'm seeing a lot of logging, but I
don't see the create trigger statements showing up in the log. What do I
need to set to get this output?

Thanks.

- DAP
------------------------------------------------------------------------
----------
David Parker Tazz Networks (401) 709-5130

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: David Parker (#1)
Re: debug levels in server

"David Parker" <dparker@tazznetworks.com> writes:

I'm trying to track down a hang in a slony "lock set" command, which
creates triggers on a set of tables. I assume that it's getting blocked
by a lock on a table somewhere, and I'd like to print out all the
"create trigger" statements in the postgres log.

I have log_min_messages = DEBUG5, and I'm seeing a lot of logging, but I
don't see the create trigger statements showing up in the log. What do I
need to set to get this output?

log_statement ...

regards, tom lane