debug levels in server

Поиск
Список
Период
Сортировка
От David Parker
Тема debug levels in server
Дата
Msg-id 07FDEE0ED7455A48AC42AC2070EDFF7C67E9D4@corpsrv2.tazznetworks.com
обсуждение исходный текст
Ответы Re: debug levels in server  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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
 

 

В списке pgsql-general по дате отправления:

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: List of Functions
Следующее
От: Peter Wiersig
Дата:
Сообщение: Had a problem with pg_clog