Request a Demo
Home   >   mailing lists

Re: [PATCH] Add ALTER SYSTEM RELOAD - Mailing list pgsql-hackers

From Dmitry Dolgov
Subject Re: [PATCH] Add ALTER SYSTEM RELOAD
Date
Msg-id arVCaX6CTKco9DEU@ddolgov-thinkpadt14sgen1.rmtde.csb
Whole thread
In response to [PATCH] Add ALTER SYSTEM RELOAD  (Yuhang Qiu <iamqyh@gmail.com>)
List pgsql-hackers
Tree view 
> On Thu, Sep 24, 2026 at 11:35:23AM +0200, Michael Banck wrote:
>
> But what could be done is add the pg_maintain (or something similar)
> default role as an allowed user for running this command besides
> Superuser.

+1, pg_maintain seems reasonable here.

Regarding the patch itself:

    +typedef enum AlterSystemAction
    +{
    +       ALTER_SYSTEM_SET,
    +       ALTER_SYSTEM_RESET,
    +       ALTER_SYSTEM_RELOAD
    +} AlterSystemAction;

What's the reason for separating SET and RESET once more? They're already
differentiated via setstmt->kind, aren't they?

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: [PATCH] Two remaining shmem attachment issues in single-user mode
Next
From: Bharath Rupireddy
Date:
Subject: Re: Teach pg_upgrade to deal with invalid databases