Re: Improving postgresql.conf - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Improving postgresql.conf
Date
Msg-id 200406161515.i5GFFgr04093@candle.pha.pa.us
Whole thread Raw
In response to Re: Improving postgresql.conf  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Improving postgresql.conf
List pgsql-hackers
Christopher Kings-Lynne wrote:
> >>The proposal is to remove the comments from postgresql.conf (like
> >>Apache) so all entries will be active.  The downside is that it will not
> >>be possible to determine which values were modified from their defaults.
> 
> One thing that truly annoys me about postgresql.conf is say I unhash an 
> option and set it to something.  Then I reload.  Then I edit the conf 
> and hash it out again, then I reload.  Of course, the option still has 
> my old value.  This is really annoying and I've wasted lots of time 
> trying to figure out what's going on.

Seems we could easily fix this by reading the config file, marking the
entries we found, and setting all the rest to default values, basically
pretending they were all specified as defaults in the config file.

This does not address the issue of someone changing the default to
another value, then commenting it out, but with the comment I assume
they would want the default, not what is specified in the file.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: OWNER TO on all objects
Next
From: Tom Lane
Date:
Subject: Re: Improving postgresql.conf