Re: logging issue - Mailing list pgsql-admin

From Jerry Sievers
Subject Re: logging issue
Date
Msg-id 87aa3tpfru.fsf@comcast.net
Whole thread Raw
In response to logging issue  ("Campbell, Lance" <lance@illinois.edu>)
Responses Re: logging issue
List pgsql-admin
"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

pgsql-admin by date:

Previous
From: "Campbell, Lance"
Date:
Subject: logging issue
Next
From: Andreas
Date:
Subject: Re: I've got gaps in the log files?