Re: Proposal for Allow postgresql.conf values to be changed via SQL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Proposal for Allow postgresql.conf values to be changed via SQL
Дата
Msg-id 12959.1352314693@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Proposal for Allow postgresql.conf values to be changed via SQL  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Proposal for Allow postgresql.conf values to be changed via SQL  (Josh Berkus <josh@agliodbs.com>)
Re: Proposal for Allow postgresql.conf values to be changed via SQL  (Amit Kapila <amit.kapila@huawei.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, Nov 7, 2012 at 12:29 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> ... we don't normally read the config file within-commands,
>> and there are both semantic and implementation problems to overcome
>> if you want to do so.

> Why would you need to?  It seems to me that we ought to be able to
> rewrite a machine-generated configuration file without loading those
> values into the current session.

Well, Magnus' proposed implementation supposed that the existing values
*have* been loaded into the current session.  I agree that with some
locking and yet more code you could implement it without that.  But this
still doesn't seem to offer any detectable benefit over value-per-file.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Proposal for Allow postgresql.conf values to be changed via SQL
Следующее
От: Andres Freund
Дата:
Сообщение: Re: crash in DROP INDEX CONCURRENTLY