Re: Permanent settings - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: Permanent settings
Date
Msg-id 87fxvoyjbm.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Permanent settings  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Permanent settings  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Permanent settings  (Magnus Hagander <magnus@hagander.net>)
Re: Permanent settings  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-hackers
"Magnus Hagander" <magnus@hagander.net> writes:

> Yeah, that may actually be a very good way to implement it. I don't like
> the idea of continously appending to an existing file, but if we did have a
> separate file with a tightly controlled format that would be doable.

+1

Separating the automatically written configuration and the explicit user
configuration is definitely the right approach. My experience comes from
Debian where packages editing their own configuration files is verboten.
Otherwise you run into problems reconciling user-made changes and automatic
changes.

The include file method is workable but isn't perfect. What happens if a user
connects with pgadmin and changes a parameter but that parameter is overridden
by a variable in the config file?

The alternative is to have two files and read them both. Then if you change a
variable which is overridden by the other source you can warn that the change
is ineffective.

I think on balance the include file method is so much simpler that I prefer it.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about
EnterpriseDB'sPostgreSQL training!
 


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Including PL/PgSQL by default
Next
From: Tom Lane
Date:
Subject: Re: Including PL/PgSQL by default