From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Log, Logs and more Logs
Date: Tue, 30 Jan 2007 12:26:51 -0500
Message-ID: <20070130172651.GD32170@phlogiston.dyndns.org> (raw)
In-Reply-To: <55c095e90701300901y41197404q4c26032ff0a28e22@mail.gmail.com>
References: <55c095e90701300901y41197404q4c26032ff0a28e22@mail.gmail.com>
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@crankycanuck.ca
If they don't do anything, we don't need their acronym.
--Josh Hamilton, on the US FEMA
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: Log, Logs and more Logs
In-Reply-To: <20070130172651.GD32170@phlogiston.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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