Request a Demo
Home   >   mailing lists

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

From Michael Banck
Subject Re: [PATCH] Add ALTER SYSTEM RELOAD
Date
Msg-id 20260924093522.GA19443@p46.dedyn.io
Whole thread
In response to Re: [PATCH] Add ALTER SYSTEM RELOAD  (Chao Li <li.evan.chao@gmail.com>)
Responses Re: [PATCH] Add ALTER SYSTEM RELOAD
List pgsql-hackers
Tree view 
Hi,

On Thu, Sep 24, 2026 at 03:39:22PM +0800, Chao Li wrote:
> Is there a reason ALTER SYSTEM RELOAD needs stronger privileges than
> pg_reload_conf()?

Well, it is clear that you won't be able to GRANT this on a SQL-level.

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.


Michael

pgsql-hackers by date:

Previous
From: Nitin Jadhav
Date:
Subject: Expose redo start information in pg_stat_recovery
Next
From: Bertrand Drouvot
Date:
Subject: Re: Persist slot invalidations before publishing them