From: | OpenMacNews <OpenMacNews(at)speakeasy(dot)net> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | howto? Fine Debugging control at cmd line |
Date: | 2005-03-02 01:21:14 |
Message-ID: | 6FA51F07A5C150620C69D8E4@tiedgar.internal.presence-group.net |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi all,
per the docs, i understand i *can* define/change the global pgsql debugging
level at the cmd line by passing, say, pg_ctl the '-o "-d 5"' option,
AND,
that i can finely change loglevel options in postgresql.conf, e.g.:
> client_min_messages = debug5 # debug5, debug4, debug3, debug2, debug1,
> # log, notice, warning, error
> log_min_messages =debug5 # debug5, debug4, debug3, debug2, debug1,
> # info, notice, warning, error, log, fatal,
panic
> log_error_verbosity = verbose # terse, default, verbose
> log_min_error_statement = debug5 # debug5, debug4, debug3, debug2, debug1,
can I, however, *individually* change these "fine" logging controls at the
command line, and simply re-HUP? e.g., for just a quick debug session?
seems like it might be reasonable to do so, but i think i'm missing the
(possibly?) obvious ...
or, does one make the change in the .conf file, and then rehup?
any pointers?
thanx!
richard
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2005-03-02 01:30:17 | Re: Index size |
Previous Message | Jonathan Hedstrom | 2005-03-02 00:53:58 | Re: Trigger email? |