Re: debugging tools inside postgres

Поиск
Список
Период
Сортировка
От Shigeru Hanada
Тема Re: debugging tools inside postgres
Дата
Msg-id 4E0488DF.2040801@gmail.com
обсуждение исходный текст
Ответ на Re: debugging tools inside postgres  (HuangQi <huangqiyx@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Steve Singer
Дата:
Сообщение: Re: Online base backup from the hot-standby
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: pg_upgrade defaulting to port 25432