From: | Brian Witt <bwitt(at)bart(dot)gov> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | use log_statement to log only SELECTs? |
Date: | 2009-01-28 17:57:15 |
Message-ID: | 1233165435.3451.1981.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I've been looking for a way to use log_statement to log only select
statements; is this possible? (I'm using PostgreSQL 8.1.11)
I'd like to know if someone tried to read the data back from the
database, but don't care to see the inserts or updates since these may
have sensitive data like credit card data which I don't want logged in
the logs. I really don't even care if the SELECT was successful or not,
or what the results of the SELECT were.
The only mention of this I can find is from the archives to
pgsql-hackers:
On Jun 2, 2003 11:51:01 am, Bruce Momjian wrote:
> I can't see why someone would want to see only SELECT and not others,
> and I can't imagine wanting modification statements and not DDL.
Thanks,
Brian
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2009-01-28 18:25:09 | Re: Slow first query despite LIMIT and OFFSET clause |
Previous Message | Tom Lane | 2009-01-28 17:39:05 | Re: possible pg_dump bug |