Re: [PATCH] Add ALTER SYSTEM RELOAD

From: Michael Banck <mbanck(at)gmx(dot)net>
To: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Cc: Yuhang Qiu <iamqyh(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] Add ALTER SYSTEM RELOAD
Date: 2026-09-24 09:35:23
Message-ID: 20260924093522.GA19443@p46.dedyn.io;lightning.p46.dedyn.io
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2026-09-24 09:41:02 Re: Persist slot invalidations before publishing them
Previous Message Nitin Jadhav 2026-09-24 09:32:04 Expose redo start information in pg_stat_recovery