Re: Proposal for Allow postgresql.conf values to be changed via SQL
Jaime Casanova <jaime@2ndquadrant.com>
From: Jaime Casanova <jaime@2ndquadrant.com>
To: Amit Kapila <amit.kapila@huawei.com>
Cc: Fujii Masao <masao.fujii@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Dimitri Fontaine <dimitri@2ndquadrant.fr>, Tom Lane <tgl@sss.pgh.pa.us>, cedric@2ndquadrant.com, Robert Haas <robertmhaas@gmail.com>, Greg Smith <greg@2ndquadrant.com>, Josh Berkus <josh@agliodbs.com>, Magnus Hagander <magnus@hagander.net>, Christopher Browne <cbbrowne@gmail.com>, Alvaro Herrera <alvherre@2ndquadrant.com>
Date: 2012-12-10T23:54:58Z
Lists: pgsql-hackers
On Fri, Nov 23, 2012 at 4:56 AM, Amit Kapila <amit.kapila@huawei.com> wrote: > On Thursday, November 22, 2012 10:09 PM Fujii Masao wrote: > >> Is it helpful to output the notice message like 'Run pg_reload_conf() or >> restart the server if you want new settings to take effect' always after >> SET PERSISTENT command? > > Not sure because if someone uses SET PERSISTENT command, he should know the > effect or behavior of same. > I think it's good to put this in UM along with "PERSISTENT" option > explanation. > can we at least send the source file in the error message when a parameter has a wrong value? suppose you do: SET PERSISTENT shared_preload_libraries TO 'some_nonexisting_lib'; when you restart postgres and that lib doesn't exist you can get confused when looking at postgresql.conf and find an empty string there -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157