On Mon, Oct 26, 2009 at 1:40 PM, Josh Berkus <j...@agliodbs.com> wrote: > > Different issue, really, which is that some people (including me) would > like to break up PostgreSQL configuration into 7 or 8 files based on > functional area (e.g. memory.conf, logging.conf, custom_options.conf > ...). I do this with my Apache configs, and find it vastly more > manageable than one big file, especially under SCM. If I write a > config management tool, my tool will also do this.
This actually seems like a bad idea to me. It's fine for something like apache virtual hosts where there's no ambiguity and in any case it's you organizing it and you reading it back out. But for a tool to do this is only going to lead to confusion when my thinking of where to find the variables differs from yours. > > That's the reason for the dir, not persistent.conf, which I agree could > be a single file. Well you're assuming there's only one tool generating this config? We have at least two and possibly more. initdb generates an initial set of defaults, the user may well run some kind of autotuning program, and then they also have variables set by SET PERSISTENT. That's three pieces of configuration being edited by different pieces of software. The only way that will stay sane will be if each piece of software has its own file to dump its own configuration into. If they start editing each others configuration it'll all be one big pile of non-deterministic spaghetti. -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers