diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-09-02 05:42:54 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-09-02 05:42:54 +0000 |
| commit | 9fd842c4b20d55746d34a96bc6baec7d2242c2cf (patch) | |
| tree | 048b493d65b0b5a531ffab5c0d88bff04b67a072 /doc/src | |
| parent | 6a8babc206976fdce1ccd8a63b85c1a01dfe148d (diff) | |
| download | postgresql-9fd842c4b20d55746d34a96bc6baec7d2242c2cf.tar.gz postgresql-9fd842c4b20d55746d34a96bc6baec7d2242c2cf.zip | |
Add GUC variable to print original query to the server logs when there
is an error, warning, etc.
Gavin Sherry
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/runtime.sgml | 29 |
1 files changed, 25 insertions, 4 deletions
diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index 42677b20e14..d43461e61b7 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.132 2002/09/01 23:26:06 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.133 2002/09/02 05:42:54 momjian Exp $ --> <Chapter Id="runtime"> @@ -942,7 +942,6 @@ env PGOPTIONS='-c geqo=off' psql </para> </listitem> </varlistentry> - <varlistentry> <term><varname>EXPLAIN_PRETTY_PRINT</varname> (<type>boolean</type>)</term> <listitem> @@ -979,6 +978,28 @@ env PGOPTIONS='-c geqo=off' psql </varlistentry> <varlistentry> + <term><varname>LOG_MIN_ERROR_STATEMENT</varname> (<type>string</type>)</term> + <listitem> + <para> + This controls which log messages are accompanied by the original + query which generated the message. All queries matching the setting + or which are of a higher severity than the setting are logged. The + default is <literal>ERROR</literal>. Valid values are + <literal>DEBUG5</literal>, <literal>DEBUG4</literal>, + <literal>DEBUG3</literal>, <literal>DEBUG2</literal>, + <literal>DEBUG1</literal>, <literal>INFO</literal>, + <literal>NOTICE</literal>, <literal>WARNING</literal> + and <literal>ERROR</literal>. + </para> + <para> + It is recommended you enable <literal>LOG_PID</literal> as well + so you can more easily match the error statement with the error + message. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><varname>LOG_PID</varname> (<type>boolean</type>)</term> <listitem> <para> @@ -1005,8 +1026,8 @@ env PGOPTIONS='-c geqo=off' psql <listitem> <para> Prints the duration of every completed query. To use this option, - enable LOG_STATEMENT and LOG_PID so you can link the original query - to the duration using the process id. + enable <literal>LOG_STATEMENT</> and <literal>LOG_PID</> so you + can link the original query to the duration using the process id. </para> </listitem> </varlistentry> |