Magnus Hagander wrote:
On Tue, Feb 19, 2008 at 03:53:11PM +0000, Richard Huxton wrote:
Magnus Hagander wrote:
What I'd really like to see is something like a new keyword on the SET
command, so you could to SET PERMANENT foo=bar, which would write the
configuration back into postgresql.conf.
I don't have a complete solution for how to actually implement it, so I'm
just throwing out some ideas for comment.
Not sure if it's of interest, but you might want to look at the postfix
mailserver configuration setup and see if that translates to an API.
postconf
lists the configuration settings (in alphabetical order)
SELECT * FROM pg_settings
postconf -n
list non-default settings
SELECT * FROM pg_settings WHERE NOT source='default'
postconf <setting>
display "setting = value"
SHOW log_destination
postconf -e <setting> = <value>
edit the configuration file, changing that setting
That's the one remaining :-)
The editing option replaces any existing version of that setting and
adds the new value at the end of the file.
Eh, it cannot both replace it, and add it at the end of the file, can it?
Does it replace it in-line, or does it remove the in-line entry and put the
new one at the end? Or are you saying it edits in-line entries and appends
new ones at the end?
Sorry,
- Edits existing lines.
- Adds new ones to end of file.
- Leaves blank lines, comments etc. alone
Having all the values at the end of the file works well, because for a
simple setup you don't need to change many settings and they don't
depend on order.
Right. I don't think we have any settings that depend on order, do we?
That's what I was trying to think of - nothing came to mind.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
