| From: | Egor Voynov <egor(dot)voynov(at)aiven(dot)io> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Access to pg_replication_origin* functions |
| Date: | 2026-02-11 08:53:58 |
| Message-ID: | CANc5o7aqz7S=7msdLD=WS4MMWC-jEM76QQy6gU7xU39uJ2==rg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all,
I have a question regarding access to replication origin functions, such
as pg_catalog.pg_replication_origin* (e.g. pg_replication_origin_oid(text))
.
At the moment, access to these functions has to be granted individually.
Should users with the REPLICATION attribute be allowed to execute them by
default?
Alternatively, would it make sense to grant this access in bulk via an
existing role like pg_create_subscription, or perhaps introduce a dedicated
predefined role for this purpose?
These functions are closely related to replication, but it’s not entirely
clear what the intended privilege model is here.
Any thoughts?
Best regards,
Egor Voynov
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wim Rouquart | 2026-02-11 09:05:08 | RE: Index (primary key) corrupt? |
| Previous Message | Durgamahesh Manne | 2026-02-11 08:53:47 | Re: Fillfactor effectiveness on existing table |