On 2013-08-01 10:13:37 -0700, Josh Berkus wrote: > On 07/26/2013 12:19 PM, Stephen Frost wrote: > > Agreed. To continue that thought, I find it *very* unlikely that a > > given environment would use *both* a tool like puppet to manage the > > files in their conf.d *and* have people using ALTER SYSTEM SET. You're > > going to do one or the other, almost certainly; not the least of which > > is because those are very likely two different teams and only one of > > them is going to be responsible for the PG system config. > > Ideally, yes. And that's the reason why I think that we will need to > implement a way to disable ALTER SYSTEM SET in postgresql.conf before > 9.4.0 is done. The big-Puppet-management shops will demand it; they do > NOT want their DBAs setting unversioned settings in isolation on one > database server out of 200.
They would need a setting that disables ALTER (DATABASE|USER) ... SET ... as well though. At least for some settings. I don't think enforcing things on that level makes much sense. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers