Re: logging issue

Thanks so much for the response.  Logging works great.

Many thanks to the PostgreSQL development team for building such a wonderful database.  9.1 is working great.

Thanks,

Lance Campbell
Software Architect
Web Services at Public Affairs
217-333-0382


-----Original Message-----
From: Jerry Sievers [mailto:gsievers19@comcast.net]
Sent: Tuesday, March 06, 2012 3:43 PM
To: Campbell, Lance
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] logging issue

"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