Re: PostgreSQL configuration - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PostgreSQL configuration
Date
Msg-id 14446.1081438339@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL configuration  (Honza Pazdziora <adelton@informatics.muni.cz>)
Responses Re: PostgreSQL configuration  (Honza Pazdziora <adelton@informatics.muni.cz>)
Re: PostgreSQL configuration  (Kevin Brown <kevin@sysexperts.com>)
List pgsql-hackers
Honza Pazdziora <adelton@informatics.muni.cz> writes:
> On Thu, Apr 08, 2004 at 10:31:44AM -0400, Tom Lane wrote:
>> It seems that MySQL *will* read /etc/my.cnf if it
>> exists, whether it's appropriate or not, and so it's impossible to have
>> a truly independent test installation, even though you can configure it
>> to build/install into nonstandard directories.  Let's not emulate that
>> bit of brain damage.

> A counterexample of Apache shows that you can easily use -f or another
> command line option to point the server to alternate master config
> file (which I believe is the same with MySQL).

According to
http://www.mysql.com/documentation/mysql/bychapter/manual_Using_MySQL_Programs.html#Option_files
/etc/my.cnf will be read if it exists, no matter what you say on the
command line.  So AFAICS the only way to make a private installation is
to make sure that you have overridden each and every setting in
/etc/my.cnf in a private config file that you do control.  This is
tedious and breakage-prone, of course.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Dennis Bjorklund
Date:
Subject: Re: locale
Next
From: Tom Lane
Date:
Subject: Re: locale