pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLogging parameters
5+ messages / 2 participants
[nested] [flat]
* Logging parameters
@ 2010-05-11 17:46 Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
0 siblings, 1 reply; 5+ messages in thread
From: Maria L. Wilson @ 2010-05-11 17:46 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Logging parameters
@ 2010-05-11 18:09 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
0 siblings, 1 reply; 5+ messages in thread
From: Kevin Grittner @ 2010-05-11 18:09 UTC (permalink / raw)
To: Maria.L.Wilson-1@nasa.gov; pgsql-admin
"Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov> wrote:
> log_statement = 'all' # none, ddl, mod, all
Try setting this to 'none'.
-Kevin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Logging parameters
@ 2010-05-11 19:23 Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 5+ messages in thread
From: Maria L. Wilson @ 2010-05-11 19:23 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS APPLICATIONS] <m.l.wilson@nasa.gov>; pgsql-admin
thanks Kevin - will any statements resulting in errors be logged no
matter how long they take?
Maria-
Kevin Grittner wrote:
> "Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov> wrote:
>
>
>> log_statement = 'all' # none, ddl, mod, all
>>
>
> Try setting this to 'none'.
>
> -Kevin
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Logging parameters
@ 2010-05-11 19:34 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
0 siblings, 1 reply; 5+ messages in thread
From: Kevin Grittner @ 2010-05-11 19:34 UTC (permalink / raw)
To: m.l.wilson@nasa.gov; Maria.L.Wilson-1@nasa.gov; +Cc: pgsql-admin
"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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Logging parameters
@ 2010-05-11 19:39 Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 5+ messages in thread
From: Maria L. Wilson @ 2010-05-11 19:39 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS APPLICATIONS] <m.l.wilson@nasa.gov>; pgsql-admin
ok - I'll set these up on our test machine. I'm not rebooting either -
just sending a reload.
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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2010-05-11 19:39 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-05-11 17:46 Logging parameters Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
2010-05-11 18:09 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-05-11 19:23 ` Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
2010-05-11 19:34 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-05-11 19:39 ` Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox