On Dec 29, 2004, at 3:16 PM, Tom Lane wrote:
> Eric Brown <eric(dot)brown(at)propel(dot)com> writes:
>> On Dec 29, 2004, at 2:28 PM, Tom Lane wrote:
>>> Eric Brown <eric(dot)brown(at)propel(dot)com> writes:
>>>> I thought setting debug_print_plan was supposed to explain every
>>>> in my log file? I don't see the plan print either.
>>> No, it just prints the plan. With settings like yours I get
>> I don't get the the "DEBUG: parse tree:" or the DETAIL lines at all.
> [ scratches head... ] Are you sure debug_print_plan is really on?
> Check it with SHOW. It's hard to see why that debug output wouldn't
> to the log if the rest of the debug messages do.
The problem was syslog. Postgresql logs to facility local0 by default
and I wasn't logging that at debug level.
In response to
pgsql-general by date
|Next:||From: Horst G. Reiterer||Date: 2004-12-30 05:11:04|
|Subject: Roadmap for Database Kernel XA Support|
|Previous:||From: Tom Lane||Date: 2004-12-29 23:30:42|
|Subject: Re: pg_dump and pgpool |