Re: SQL command to edit postgresql.conf, with comments

Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr> writes:
> Ok, now, some people want to still be able to edit the files by hand

I wonder if providing a system function to load some configuration
option from a file, using the current parser, would do it:

SELECT pg_load_conf('path/to/filename.conf', permament => true);

Of course comments are ignored. Settings in the directory would be
changed according to what's in your file, so that it'd be roughtly
equivalent as current steps:
a. edit the file
b. use pg_load_conf() rather than pg_reload_conf()

Comments?
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support