<br /><br /> Tom Lane wrote:<br /><blockquote cite="mid10922.1045115467@sss.pgh.pa.us" type="cite"><pre wrap="">mlw <a
class="moz-txt-link-rfc2396E"href="mailto:pgsql@mohawksoft.com"><pgsql@mohawksoft.com></a> writes:
</pre><blockquotetype="cite"><pre wrap="">The idea that a, more or less, arbitrary data location determines the
database configuration is wrong. It should be obvious to any
administrator that a configuration file location which controls the
server is the "right" way to do it. </pre></blockquote><pre wrap="">
I guess I'm just dense, but I entirely fail to see why this is the One
True Way To Do It. What you seem to be proposing (ignoring
syntactic-sugar issues) is that we replace "postmaster -D
/some/data/dir" by "postmaster -config /some/config/file". I am not
seeing the nature of the improvement. It looks to me like the sysadmin
must now grant the Postgres DBA write access on *two* directories, viz
/some/config/ and /wherever/the/data/directory/is. How is that better
than granting write access on one directory? Given that we can't manage
to standardize the data directory location across multiple Unixen, how
is it that we will be more successful at standardizing a config file
location?
All I see here is an arbitrary break with our past practice. I do not
see any net improvement.
</pre></blockquote> There is a pretty well understood convention that a configuration file will be located in some
standardlocation depending on your distro. Would you disagree with that?<br /><br /> There is also a convention that
mostservers are configured by a configuration file, located in a central location. Look at sendmail, named,, et al. <br
/><br/> Here is the test, configure a server, with sendmail, named, apache, and PostgreSQL. Tell me which of these
systemsdoesn't configure right.<br />