On 08/05/2013 10:49 AM, Stephen Frost wrote: > Josh, I really have to ask- are these people who are implementing puppet > to control these configs really clamoring to have an 'ALTER SYSTEM' PG > command to have to code against instead of dealing with text files? I > feel like you're arguing for these parameters to be modifiable through > ALTER SYSTEM on the grounds that these parameters need to be set at some > point and in some way and not because having them set through ALTER > SYSTEM actually makes any *sense*.
Nope. ALTER SYSTEM, from my POV, is mainly for folks who *don't* use Puppet/Chef/whatever. Here's where I see ALTER SYSTEM being useful: * invididually managed servers with out centralized management (i.e. one DBA, one server). * developer machines (i.e. laptops and vms) * automated testing of tweaking performance parameters * setting logging parameters temporarily on systems under centralized management For that reason, the only way in which I think it makes sense to try to make ALTER SYSTEM set work together with Puppet/Chef is in the rather limited context of modifying the logging settings for limited-time data collection. Mostly, ALTER SYSTEM SET is for systems were people *aren't* using Puppet/Chef. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers