Re: Logging statements with errors in PostgreSQL 8.1

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Logging statements with errors in PostgreSQL 8.1
Дата
Msg-id 4AE601F0.30206@hogranch.com
обсуждение исходный текст
Ответ на Logging statements with errors in PostgreSQL 8.1  (Radcon Entec <radconentec@yahoo.com>)
Список pgsql-general
Radcon Entec wrote:
> Is there any way to get a PostgreSQL 8.1 installation to report the
> statements that caused the error, as the 8.3 installation does?

see
http://www.postgresql.org/docs/8.1/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT
specifically, log_statement, and log_line_prefix
<http://www.postgresql.org/docs/8.1/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT>

afaik, these options are just about identical from 8.1 to 8.3, so look
at your 8.3 postgresql.conf file, and you should be able to copy those
options to the 8.1 file.




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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Logging statements with errors in PostgreSQL 8.1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Why does pg_dump set default_with_oids to true?