[GENERAL] use log_statement to log only SELECTs?
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.18) 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. Thanks, Brian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] use log_statement to log only SELECTs?
On Sun, 2009-11-29 at 06:00 -0500, Bruce Momjian wrote: > Brian Witt wrote: > > 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.18) > No, log_statement doesn't allow do that, and I can't think of another > option. Thanks for the response. I was afraid of that. Can I make this a feature request? How do I do that? Should I add it to this page: http://wiki.postgresql.org/wiki/Todo Thanks again, Brian signature.asc Description: This is a digitally signed message part
[GENERAL] use log_statement to log only SELECTs?
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
