Re: PostgreSQL configuration

Bruce Momjian wrote:

>Mark Kirkwood wrote:
>  
>
>>Bruce Momjian wrote:
>>
>>    
>>
>>>My idea was to put config files in /usr/local/pgsql/data/etc, not
>>>
>>>pgsql/etc.
>>>
>>>We don't put Unix configuration files in /, etc put them in /etc.
>>>
>>> 
>>>
>>>      
>>>
>>Sorry, I missed the 'data' pathname. However - I may be a bit slow - but 
>>I do not see how this will handle the situation where you have one 
>>installation of pgsql running several clusters. (I am not sure how 
>>common this situation is mind you)
>>    
>>
>
>It is common.  Moving things to data/etc will make things clearer, and
>see my later email on an initdb option to put /data/etc/ somewhere else
>and put a symlink for /data/etc.
>  
>
Hmmm, the current setup handles this situation sensibly and without the need for symlinks. So this does not look like
animprovement to me...
 

This *could* work without symlinks if you introduce a "name" for each initialized cluster, and make this part of the
configfile name. This would mean that you could use 'data/etc' and have many config files therein, each of which would
*unambiguously*point to a given cluster. 
 

As a general point I share Tom's concern about breaking the association between the initialized cluster and its
configurationfile - e.g: I start "prod" with the configuration for "test" by mistake, and "test" has fsync=false... and
somethingpulls the power... 
 

regards

Mark