Re: Permanent settings

Magnus Hagander wrote:
> On Tue, Feb 19, 2008 at 03:53:11PM +0000, Richard Huxton wrote:
>> Magnus Hagander wrote:
>>> What I'd really like to see is something like a new keyword on the SET
>>> command, so you could to SET PERMANENT foo=bar, which would write the
>>> configuration back into postgresql.conf.
>>>
>>> I don't have a complete solution for how to actually implement it, so I'm
>>> just throwing out some ideas for comment.
>> Not sure if it's of interest, but you might want to look at the postfix 
>> mailserver configuration setup and see if that translates to an API.
>>
>> postconf
>>   lists the configuration settings (in alphabetical order)
> 
> SELECT * FROM pg_settings
> 
>> postconf -n
>>   list non-default settings
> 
> SELECT * FROM pg_settings WHERE NOT source='default'
> 
>> postconf <setting>
>>   display "setting = value"
> 
> SHOW log_destination
> 
>> postconf -e <setting> = <value>
>>   edit the configuration file, changing that setting
> 
> That's the one remaining :-)
> 
> 
>> The editing option replaces any existing version of that setting and 
>> adds the new value at the end of the file.
> 
> Eh, it cannot both replace it, and add it at the end of the file, can it?
> Does it replace it in-line, or does it remove the in-line entry and put the
> new one at the end? Or are you saying it edits in-line entries and appends
> new ones at the end?

Sorry, - Edits existing lines. - Adds new ones to end of file. - Leaves blank lines, comments etc. alone

>> Having all the values at the end of the file works well, because for a 
>> simple setup you don't need to change many settings and they don't 
>> depend on order.
> 
> Right. I don't think we have any settings that depend on order, do we?

That's what I was trying to think of - nothing came to mind.

--   Richard Huxton  Archonet Ltd