| From: | Jerry Sievers <gsievers19(at)comcast(dot)net> |
|---|---|
| To: | "Campbell\, Lance" <lance(at)illinois(dot)edu> |
| Cc: | "pgsql-admin\(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: logging issue |
| Date: | 2012-03-06 21:43:01 |
| Message-ID: | 87aa3tpfru.fsf@comcast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"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 | Todd Hunt | 2012-03-06 22:03:01 | Looking for help on backing up a large database (500GB+) with LOBs |
| Previous Message | Campbell, Lance | 2012-03-06 21:04:23 | logging issue |