Re: debug levels in server - Mailing list pgsql-general

From Tom Lane
Subject Re: debug levels in server
Date
Msg-id 26969.1114149030@sss.pgh.pa.us
Whole thread Raw
In response to debug levels in server  ("David Parker" <dparker@tazznetworks.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Dinesh Pandey"
Date:
Subject: How to install Postgres that supports 64-bit integer/date-time.
Next
From: Tom Lane
Date:
Subject: Re: Waiting for Disconnect