Обсуждение: Logging parameters
Trying to do some modifications to the amount of logging that our postgres database server (8.4 on linux) does on our production servers and had a few questions that I hope someone would clear up. Basically - in production, it would be nice to limit some of the logging and let the dev/test database servers be the most verbose. It was my understanding that I could do this by setting log_min_duration_statement to some large interval and I would not see all the other SQL. This does not seem to be the case. What it looks like it's doing is just not showing the duration of the SQL unless it is longer than this parameter. What I'm trying to do is limit what is logged on production to be only the necessary stuff.... Here's my parameters currently..... #client_min_messages = notice #log_min_messages = notice #log_error_verbosity = default # terse, default, or verbose messages #log_min_error_statement = error log_min_duration_statement = 2000 # -1 is disabled, 0 logs all statements # and their durations. #silent_mode = off debug_pretty_print = on log_connections = on log_disconnections = on log_duration = on log_line_prefix = '%u %h %m [%p] [%d] ' # Special values: log_statement = 'all' # none, ddl, mod, all Could you all give me some recommendations?? thanks!! Maria Wilson NASA/Langley Research Center Hampton, Virginia 23681
"Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov> wrote: > log_statement = 'all' # none, ddl, mod, all Try setting this to 'none'. -Kevin
thanks Kevin - will any statements resulting in errors be logged no matter how long they take?
Maria-
Kevin Grittner wrote:
Maria-
Kevin Grittner wrote:
"Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov> wrote:log_statement = 'all' # none, ddl, mod, allTry setting this to 'none'. -Kevin
"Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov> wrote: > thanks Kevin - will any statements resulting in errors be logged > no matter how long they take? I believe so, but my naturally paranoid nature always has me testing such things before I roll them to production. ;-) It's always possible I misunderstood or overlooked something.... -Kevin
ok - I'll set these up on our test machine. I'm not rebooting either - just sending a reload.
Kevin Grittner wrote:
Kevin Grittner wrote:
"Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov> wrote:thanks Kevin - will any statements resulting in errors be logged no matter how long they take?I believe so, but my naturally paranoid nature always has me testing such things before I roll them to production. ;-) It's always possible I misunderstood or overlooked something.... -Kevin