| From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Log, Logs and more Logs |
| Date: | 2007-01-30 17:26:51 |
| Message-ID: | 20070130172651.GD32170@phlogiston.dyndns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-sql |
On Tue, Jan 30, 2007 at 03:01:05PM -0200, Ezequias Rodrigues da Rocha wrote:
> I know there are many logs in postgresql but I don't have many
> familiarity with all them.
It's not totally plain what you want to have happen -- whether you
want all queries, whether you merely want ERRORs to show up in your
logs, or whether you want only ERRORS to show their queries. If it's
the latter, then my suggestion is to set log_min_messages to ERROR
and log_min_error_statement to ERROR as well.
The section of the manual you really want to read is
http://www.postgresql.org/docs/8.2/static/runtime-config-logging.html
A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
If they don't do anything, we don't need their acronym.
--Josh Hamilton, on the US FEMA
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ezequias Rodrigues da Rocha | 2007-01-30 18:41:13 | Re: Log, Logs and more Logs |
| Previous Message | Ezequias Rodrigues da Rocha | 2007-01-30 17:01:05 | Log, Logs and more Logs |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoff Tolley | 2007-01-30 18:14:26 | Re: Differentiate Between Zero-Length String and NULLColumn Values |
| Previous Message | Ezequias Rodrigues da Rocha | 2007-01-30 17:01:05 | Log, Logs and more Logs |