Re: debugging tools inside postgres - Mailing list pgsql-hackers

From Shigeru Hanada
Subject Re: debugging tools inside postgres
Date
Msg-id 4E0488DF.2040801@gmail.com
Whole thread Raw
In response to Re: debugging tools inside postgres  (HuangQi <huangqiyx@gmail.com>)
List pgsql-hackers
(2011/06/24 19:14), HuangQi wrote:
> 2011/6/24 Shigeru Hanada<shigeru.hanada@gmail.com>
> 
>> (2011/06/24 15:35), HuangQi wrote:
>> ex)
>>         elog(DEBUG1, "%s", nodeToString(plan));
> 
> Hi,
>     I don't know why but when I am debugging the query evaluation, the elog
> function can not output to shell.

What kind of tool do you use to execute the query to be evaluated?

If you are using an interactive tool such as psql, please check setting
of client_min_messages.  Otherwise, please check settings of
log_destination, logging_collector and log_min_messages to ensure that
elog() prints debugging information into your server log file, or stderr
of the terminal which has been used to start PostgreSQL server.

Regards,
-- 
Shigeru Hanada


pgsql-hackers by date:

Previous
From: Steve Singer
Date:
Subject: Re: Online base backup from the hot-standby
Next
From: Peter Eisentraut
Date:
Subject: Re: pg_upgrade defaulting to port 25432