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:[email protected]] Sent: Tuesday, March 06, 2012 3:43 PM To: Campbell, Lance Cc: [email protected] Subject: Re: [ADMIN] logging issue "Campbell, Lance" <[email protected]> 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: [email protected] p: 305.321.1144 -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
