From: Jerry Sievers <gsievers19@comcast.net>
To: Campbell\, Lance <lance@illinois.edu>
Cc: pgsql-admin\@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: logging issue
Date: Tue, 06 Mar 2012 16:43:01 -0500
Message-ID: <87aa3tpfru.fsf@comcast.net> (raw)
In-Reply-To: <B75CD08C73BD3543B97E4EF3964B7D701E3CF9AF@CITESMBX5.ad.uillinois.edu>
References: <B75CD08C73BD3543B97E4EF3964B7D701E3CF9AF@CITESMBX5.ad.uillinois.edu>
"Campbell, Lance" <lance@illinois.edu> writes:
> PostgreSQL 9.1.3
>
> I just moved our test database from PostgreSQL 9.0 to 9.1. I also
> changed my log settings. I am seeing every single SQL statement
> that PostgreSQL performs by my Java applications. Is there some way
> to only display the details when there is an error? I would assume
> yes. But for some reason I am getting all SQL statements. I just
> want the errors. I have included below my settings for the logging
> section. Any help would be greatly appreciated. Thanks!
>
Change log_statement to 'none' and pg_ctl reload the server.
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 305.321.1144
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-admin@postgresql.org
Cc: gsievers19@comcast.net, lance@illinois.edu
Subject: Re: logging issue
In-Reply-To: <87aa3tpfru.fsf@comcast.net>
* 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