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