On fre, 2010-12-10 at 10:01 -0800, Wells Oliver wrote: > Hello- a quick question about logging. I'm trying to set logging to the > most minimal level possible. e.g. I really don't want to see the > following kind of thing: > > 2010-12-10 09:59:40 PST FATAL: database "woliver" does not exist > > Because... so what? Some guy forgot to supply the DB name. I've looked > over the logging options in the documentation and they are legion. What > are my key options to reduce logging to the lowest, most vital sort of > messages? The problem is, the distinction of severity is actually not so much about what is important to you the DBA, but what is important to the session process. The above is important to the session process because the session cannot continue after that error. Other, more severe problems will only show up as "error" because the session can continue. So unless you want to set log_min_messages to panic, which pretty much means that by the time you see the message your database system is dead, you probably want to log everything at least on level error or warning and then rely on a log analysis tool and/or other monitoring to work out what is important to you. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
