Re: another idea for changing global configuration settings from SQL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: another idea for changing global configuration settings from SQL
Date
Msg-id 19176.1353093384@sss.pgh.pa.us
Whole thread Raw
In response to Re: another idea for changing global configuration settings from SQL  (Hannu Krosing <hannu@krosing.net>)
List pgsql-hackers
Hannu Krosing <hannu@krosing.net> writes:
> Can't we keep a separate text .conf file specifically for the background
> processes which can't read system catalogs. It could contain only the
> GUCs these processes are interested in.

What's the value of that, compared to the existing proposal for
write-a-text-file-directly?  It seems like useless complication.

If we could move *all* the GUCs into system catalogs, maybe it'd be
worth the trouble, but I think that's a fundamentally bad idea.
It will make it impossible to change settings when the system is down,
and thus for example impossible to fix configuration errors that
prevent the postmaster from starting.  I think we should stick with
the principle that the text file is the primary authority, and that
means we don't need a system catalog entry for global settings.

A possibly instructive precedent is that we got rid of
pg_tablespace.spclocation after deciding it was counterproductive
to have a catalog entry that wasn't the authoritative state.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: another idea for changing global configuration settings from SQL
Next
From: Atri Sharma
Date:
Subject: Re: WIP patch for hint bit i/o mitigation