Re: Improving postgresql.conf

On Jun 16, 2004, at 1:05 PM, 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.

A habit I've gotten into for editing config files that have commented
defaults is to copy the line with the setting, uncomment the copied
line, and change it to my setting.

Would it help to have two lines in the config file for each setting,
one with the default (comment) and one with the actual setting? So for
example, the postgresql.conf would ship with something like this:

#tcpip_socket = false #default
tcpip_socket = false

If the user wants to connect via tcp_ip, they can edit it like this:
#tcpip_socket = false #default
tcpip_socket = true

The default is still there for reference, and they can see what the
current setting is. Granted, there's redundancy in having the commented
line and the uncommented line (if I understand the defaults correctly),
but it might be useful redundancy. Users would have easy reference to
what the "factory settings" are.

Michael Glaesemann
grzm myrealbox com