Re: Possibility to disable `ALTER SYSTEM`

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Possibility to disable `ALTER SYSTEM`
Дата
Msg-id ZgXR5T7SZUykZGFT@momjian.us
обсуждение исходный текст
Ответ на Re: Possibility to disable `ALTER SYSTEM`  (Jelte Fennema-Nio <postgres@jeltef.nl>)
Список pgsql-hackers
On Thu, Mar 28, 2024 at 01:23:36PM +0100, Jelte Fennema-Nio wrote:
> +       <para>
> +        Turning this setting off is intended for environments where the
> +        configuration of <productname>PostgreSQL</productname> is managed by
> +        some external tool.
> +        In such environments, a well intentioned superuser might
> +        <emphasis>mistakenly</emphasis> use <command>ALTER SYSTEM</command>
> +        to change the configuration instead of using the external tool.
> +        This might result in unintended behavior, such as the external tool
> +        discarding the change at some later point in time when it updates the

"discarding" -> "overwriting" ?

> +  <para>
> +   <literal>ALTER SYSTEM</literal> can be disabled by setting
> +   <xref linkend="guc-allow-alter-system"/> to <literal>off</literal>, but this
> +   is no security mechanism (as explained in detail in the documentation for

"is no" -> "is not a"

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Properly pathify the union planner
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Streaming I/O, vectored I/O (WIP)