Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])

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