Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review]) - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])
Date
Msg-id 20130730171030.GQ14652@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])  (Josh Berkus <josh@agliodbs.com>)
Responses Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])
List pgsql-hackers
Josh Berkus escribió:
> Amit,
> 
> > I had already sent the updated patch based on recent suggestions.
> 
> Yes, but there is no consensus yet on certain fundamental issues, such as:
> 
> 1. what directory should postgresql.auto.conf live in?
> 
> 2. should admins be able to turn it "off"?
> 
> Once we have consensus on these issues, then hopefully we can commit
> your patch.  I don't *think* anyone is arguing with the code at this stage.

There's one other thing, raised by Cédric upthread, about the multiple
files vs. single file.  We decided on a single file because Greg said
many little files scattered in conf.d/ would be a mess; but if we're
going to have two new items, one conf.d/ for snippets from external
tools (living in the config directory) and one for ALTER SYSTEM (living
in PGDATA), then the idea of going back to one setting per file is
perhaps not bad.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])
Next
From: Greg Stark
Date:
Subject: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])