From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | chaolpan(at)cisco(dot)com |
Subject: | BUG #17377: only superusers can query or manipulate replication origins |
Date: | 2022-01-22 09:12:05 |
Message-ID: | 17377-edc40f0a4d80eaf8@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 17377
Logged by: James Pang
Email address: chaolpan(at)cisco(dot)com
PostgreSQL version: 13.4
Operating system: RHEL8.4
Description:
PG 13.4 on RHEL8.4 ,
we have a user with REPLICATION for logical replication , try to handle
"replication change loop back" by set replication origin,
select pg_replication_origin_create('test');
ERROR: only superusers can query or manipulate replication origins
Is it possible to "remove superuser() check" for pg_replication related
functions and view query, we expect any role with replication can
create/drop origin, and roles with pg_monitor can query the progress.
we tested that PG 14.1 works if we grant execution privileges , is it
possible to merge the similar enhancement to Postgresql 13.5 or next minor
version ? so we can use that in pg13 version.
Thanks,
James
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2022-01-23 02:55:18 | BUG #17378: WRONG VALUE ON - A.2. Time Zones |
Previous Message | David G. Johnston | 2022-01-22 06:33:18 | Re: BUG #17376: Adding unique column with a function() default results in "could not read block 0 in file" error |