debug levels in server

From: "David Parker" <dparker(at)tazznetworks(dot)com>
To: "postgres general" <pgsql-general(at)postgresql(dot)org>
Subject: debug levels in server
Date: 2005-04-21 18:10:09
Message-ID: 07FDEE0ED7455A48AC42AC2070EDFF7C67E9D4@corpsrv2.tazznetworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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


Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Wiersig 2005-04-21 18:39:06 Had a problem with pg_clog
Previous Message Oleg Bartunov 2005-04-21 17:56:30 Re: List of Functions