Re: Possibility to disable `ALTER SYSTEM` - Mailing list pgsql-hackers

From Gabriele Bartolini
Subject Re: Possibility to disable `ALTER SYSTEM`
Date
Msg-id CA+VUV5qxjvaJX9fUf0R-fWPp8p9n40-h7S1xMdMtxKN57yXiAw@mail.gmail.com
Whole thread Raw
In response to Re: Possibility to disable `ALTER SYSTEM`  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
Hi Magnus,

On Fri, 8 Sept 2023 at 23:43, Magnus Hagander <magnus@hagander.net> wrote:
+1. And to make that happen, the appropriate thing is to identify
*why* they are using superuser today, and focus efforts on finding
ways for them to do that without being superuser.

As I am explaining in the other post (containing a very basic proof of concept patch), it is not about restricting superuser. It is primarily a usability and configuration matter of a running instance, which helps control an entire cluster like in the case of Kubernetes (where, in order to provide self-healing and high availability we are forced to go beyond the single instance and think in terms of primary with one or more standbys or at least continuous backup in place).

Thanks,
Gabriele
--
Gabriele Bartolini
Vice President, Cloud Native at EDB

pgsql-hackers by date:

Previous
From: Steve Chavez
Date:
Subject: Add pg_basetype() function to obtain a DOMAIN base type
Next
From: jian he
Date:
Subject: Re: SQL:2011 application time