Re: [PATCH] Add ALTER SYSTEM RELOAD

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Cc: Michael Banck <mbanck(at)gmx(dot)net>, Yuhang Qiu <iamqyh(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] Add ALTER SYSTEM RELOAD
Date: 2026-09-24 11:57:11
Message-ID: 573EAB2C-E0FB-48AD-9341-4C14408CF45B@yesql.se
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 24 Sep 2026, at 13:38, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com> wrote:

> Yeah, that could be a solution. But the current patch only allows super user:

> + if (!superuser())
> + ereport(ERROR,
> + (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
> + errmsg("permission denied to perform ALTER SYSTEM RELOAD")));

I don't have a strong opinion either way, but if this check remains the error
message we commonly use is "must be superuser to ..."

--
Daniel Gustafsson

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Trakshan Mishra 2026-09-24 11:59:09 Request to expedite commitfest account cool-off
Previous Message Heikki Linnakangas 2026-09-24 11:51:44 Re: [PATCH] Assertion in pg_get_shmem_pagesize() in single-user mode