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
Re: [GENERAL] use log_statement to log only SELECTs?
Brian Witt wrote: 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 Generally it's better to see if there's at least some general support for an idea before adding it to the TODO list. In this case, I don't think you'll find any. The current way you get everything out of log_statement is completely reasonable for most people, and I doubt you'll ever get one of the folks who hack on PostgreSQL to work on the feature you'd like unless you paid them to. You'd need a much better justification for why you can't just filter things out of the log yourself before it would be worth further complicating the code involved. It's just not a common request--if anything, you might find people want everything *but* SELECTs. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- 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?
Brian Witt wrote: 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. No, log_statement doesn't allow do that, and I can't think of another option. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[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
[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