From c74c7e604cb739ce3c5821d88f8328b5b2a233c3 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 2 Oct 2002 16:27:57 +0000 Subject: [PATCH] Turn GUC log_min_error_statement off by default by setting it to PANIC. --- doc/src/sgml/runtime.sgml | 18 +++++++++--------- src/backend/utils/misc/guc.c | 15 +++++++++++++-- 2 files changed, 22 insertions(+), 11 deletions(-) diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index 36adf5ec94..1bb3ce7f07 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -1,5 +1,5 @@ @@ -1036,15 +1036,15 @@ env PGOPTIONS='-c geqo=off' psql LOG_MIN_ERROR_STATEMENT (string) - 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 ERROR. Valid values are - DEBUG5, DEBUG4, - DEBUG3, DEBUG2, + This controls which message types output the original query to + the server logs. All queries matching the setting or higher are + logged. The default is PANIC. Valid values + are DEBUG5, DEBUG4, + DEBUG3, DEBUG2, DEBUG1, INFO, - NOTICE, WARNING - and ERROR. + NOTICE, WARNING, + ERROR, FATAL, and + PANIC. It is recommended you enable LOG_PID as well diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index fa2057ca93..2e386afab1 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -5,7 +5,7 @@ * command, configuration file, and command line options. * See src/backend/utils/misc/README for more information. * - * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.96 2002/09/22 19:52:38 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.97 2002/10/02 16:27:57 momjian Exp $ * * Copyright 2000 by PostgreSQL Global Development Group * Written by Peter Eisentraut . @@ -104,7 +104,7 @@ bool Password_encryption = true; int log_min_error_statement = ERROR; char *log_min_error_statement_str = NULL; -const char log_min_error_statement_str_default[] = "error"; +const char log_min_error_statement_str_default[] = "panic"; int server_min_messages = NOTICE; char *server_min_messages_str = NULL; @@ -3000,6 +3000,17 @@ assign_msglvl(int *var, const char *newval, bool doit, bool interactive) if (doit) (*var) = ERROR; } + /* We allow FATAL/PANIC for client-side messages too. */ + else if (strcasecmp(newval, "fatal") == 0) + { + if (doit) + (*var) = FATAL; + } + else if (strcasecmp(newval, "panic") == 0) + { + if (doit) + (*var) = PANIC; + } else return NULL; /* fail */ return newval; /* OK */ -- 2.11.0