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:gsiever...@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" <la...@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.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
