diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2008-03-10 03:22:29 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2008-03-10 03:22:29 +0000 |
| commit | 2abf130a4efc0eb59f428e0fd2b4b300d372254a (patch) | |
| tree | c38b5f0ed85603b47f529648ff81bf68174fc705 | |
| parent | 7953fdcd9ecf3edf2ba14dd6d46e9f98cdf838be (diff) | |
Increase the default value of log_min_messages to WARNING, so that
NOTICE-grade messages are not logged by default. Per pgsql-hackers
discussion back on 21-Nov-2007.
| -rw-r--r-- | doc/src/sgml/config.sgml | 4 | ||||
| -rw-r--r-- | src/backend/utils/misc/guc.c | 6 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 2 |
3 files changed, 6 insertions, 6 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 677fd4d7bf5..0c2740890da 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.168 2008/03/09 04:56:28 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.169 2008/03/10 03:22:29 tgl Exp $ --> <chapter Id="runtime-config"> <title>Server Configuration</title> @@ -2582,7 +2582,7 @@ local0.* /var/log/postgresql <literal>ERROR</>, <literal>LOG</>, <literal>FATAL</>, and <literal>PANIC</>. Each level includes all the levels that follow it. The later the level, the fewer messages are sent - to the log. The default is <literal>NOTICE</>. Note that + to the log. The default is <literal>WARNING</>. Note that <literal>LOG</> has a different rank here than in <varname>client_min_messages</>. Only superusers can change this setting. diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 1acf2bc0622..2616c979535 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -10,7 +10,7 @@ * Written by Peter Eisentraut <peter_e@gmx.net>. * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.434 2008/03/09 04:56:28 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.435 2008/03/10 03:22:29 tgl Exp $ * *-------------------------------------------------------------------- */ @@ -209,7 +209,7 @@ bool SQL_inheritance = true; bool Password_encryption = true; int log_min_error_statement = ERROR; -int log_min_messages = NOTICE; +int log_min_messages = WARNING; int client_min_messages = NOTICE; int log_min_duration_statement = -1; int log_temp_files = -1; @@ -1935,7 +1935,7 @@ static struct config_string ConfigureNamesString[] = "includes all the levels that follow it.") }, &log_min_messages_str, - "notice", assign_log_min_messages, NULL + "warning", assign_log_min_messages, NULL }, { diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index d3604c2d5c0..e5ae0e85188 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -278,7 +278,7 @@ # warning # error -#log_min_messages = notice # values in order of decreasing detail: +#log_min_messages = warning # values in order of decreasing detail: # debug5 # debug4 # debug3 |