Re: Improving postgresql.conf

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Improving postgresql.conf
Date: 2004-06-16 16:52:54
Message-ID: 40D07AE6.9080003@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Stark wrote:

>Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
>
>
>
>>The only real problem I see is that showing all the values as comments
>>encourages the idea that you can undo a change by undoing your edit.
>>The simple and obvious fix is to not show the values as comments ...
>>
>>

I agree.
A good way how to describe a config variable is present for
listen_addresses, which clearly states the default value. Could be even
shorter, e.g.
port = 5432 # default: 5432

To solve the "commenting out a setting doesn't return to default'
problem a magic word 'default' could be introduced, forcing to load the
default setting.

How about *requiring* to set any variable, at least to xxx='default'?
This would remove any ambiguities (and force to review postgresql.conf
after upgrading, which is a good idea anyway).

Regards,
Andreas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-06-16 17:51:42 Re: Improving postgresql.conf
Previous Message Josh Berkus 2004-06-16 16:50:07 Re: Improving postgresql.conf