Skip to content

Commit c74c7e6

Browse files
committed
Turn GUC log_min_error_statement off by default by setting it to PANIC.
1 parent fd972e7 commit c74c7e6

File tree

2 files changed

+22
-11
lines changed

2 files changed

+22
-11
lines changed

doc/src/sgml/runtime.sgml

Lines changed: 9 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.141 2002/09/27 02:04:39 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.142 2002/10/02 16:27:57 momjian Exp $
33
-->
44

55
<Chapter Id="runtime">
@@ -1036,15 +1036,15 @@ env PGOPTIONS='-c geqo=off' psql
10361036
<term><varname>LOG_MIN_ERROR_STATEMENT</varname> (<type>string</type>)</term>
10371037
<listitem>
10381038
<para>
1039-
This controls which log messages are accompanied by the original
1040-
query which generated the message. All queries matching the setting
1041-
or which are of a higher severity than the setting are logged. The
1042-
default is <literal>ERROR</literal>. Valid values are
1043-
<literal>DEBUG5</literal>, <literal>DEBUG4</literal>,
1044-
<literal>DEBUG3</literal>, <literal>DEBUG2</literal>,
1039+
This controls which message types output the original query to
1040+
the server logs. All queries matching the setting or higher are
1041+
logged. The default is <literal>PANIC</literal>. Valid values
1042+
are <literal>DEBUG5</literal>, <literal>DEBUG4</literal>,
1043+
<literal>DEBUG3</literal>, <literal>DEBUG2</literal>,
10451044
<literal>DEBUG1</literal>, <literal>INFO</literal>,
1046-
<literal>NOTICE</literal>, <literal>WARNING</literal>
1047-
and <literal>ERROR</literal>.
1045+
<literal>NOTICE</literal>, <literal>WARNING</literal>,
1046+
<literal>ERROR</literal>, <literal>FATAL</literal>, and
1047+
<literal>PANIC</literal>.
10481048
</para>
10491049
<para>
10501050
It is recommended you enable <literal>LOG_PID</literal> as well

src/backend/utils/misc/guc.c

Lines changed: 13 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -5,7 +5,7 @@
55
* command, configuration file, and command line options.
66
* See src/backend/utils/misc/README for more information.
77
*
8-
* $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.96 2002/09/22 19:52:38 tgl Exp $
8+
* $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.97 2002/10/02 16:27:57 momjian Exp $
99
*
1010
* Copyright 2000 by PostgreSQL Global Development Group
1111
* Written by Peter Eisentraut <peter_e@gmx.net>.
@@ -104,7 +104,7 @@ bool Password_encryption = true;
104104

105105
int log_min_error_statement = ERROR;
106106
char *log_min_error_statement_str = NULL;
107-
const char log_min_error_statement_str_default[] = "error";
107+
const char log_min_error_statement_str_default[] = "panic";
108108

109109
int server_min_messages = NOTICE;
110110
char *server_min_messages_str = NULL;
@@ -3000,6 +3000,17 @@ assign_msglvl(int *var, const char *newval, bool doit, bool interactive)
30003000
if (doit)
30013001
(*var) = ERROR;
30023002
}
3003+
/* We allow FATAL/PANIC for client-side messages too. */
3004+
else if (strcasecmp(newval, "fatal") == 0)
3005+
{
3006+
if (doit)
3007+
(*var) = FATAL;
3008+
}
3009+
else if (strcasecmp(newval, "panic") == 0)
3010+
{
3011+
if (doit)
3012+
(*var) = PANIC;
3013+
}
30033014
else
30043015
return NULL; /* fail */
30053016
return newval; /* OK */

0 commit comments

Comments
 (0)