From: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
---|---|
To: | Jerry Sievers <gsievers19(at)comcast(dot)net> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: logging issue |
Date: | 2012-03-07 18:28:45 |
Message-ID: | B75CD08C73BD3543B97E4EF3964B7D701E3D0B21@CITESMBX5.ad.uillinois.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)comcast(dot)net]
Sent: Tuesday, March 06, 2012 3:43 PM
To: Campbell, Lance
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] logging issue
"Campbell, Lance" <lance(at)illinois(dot)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(dot)consulting(at)comcast(dot)net
p: 305.321.1144
From | Date | Subject | |
---|---|---|---|
Next Message | umashankar narayanan | 2012-03-07 21:59:20 | Postgres server crashing unexpectedly. |
Previous Message | Ray Stell | 2012-03-07 18:26:11 | Re: table names seem identical |