Re: Possibility to disable `ALTER SYSTEM`

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Possibility to disable `ALTER SYSTEM`
Дата
Msg-id CAKAnmmJv_ZHKo0tsxfd2+QdszcOMMkeTpAbrA=rCh4H5DgmyFA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Possibility to disable `ALTER SYSTEM`  (Gabriele Bartolini <gabriele.bartolini@enterprisedb.com>)
Ответы Re: Possibility to disable `ALTER SYSTEM`  (Gabriele Bartolini <gabriele.bartolini@enterprisedb.com>)
Список pgsql-hackers
Seems to be some resistance to getting this in core, so why not just use an extension? I was able to create a quick POC to do just that. Hook into PG and look for AlterSystemStmt, throw a "Sorry, ALTER SYSTEM is not currently allowed" error. Put into shared_preload_libraries and you're done. As a bonus, works on all supported versions, so no need to wait for Postgres 17 - or Postgres 18/19 given the feature drift this thread is experiencing :)

Cheers,
Greg

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

Предыдущее
От: Nathan Bossart
Дата:
Сообщение: Re: Add 'worker_type' to pg_stat_subscription
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Eliminate redundant tuple visibility check in vacuum