public inbox for [email protected]  

help / color / mirror / Atom feed

From: Egor Voynov <[email protected]>
To: [email protected]
Subject: Access to pg_replication_origin* functions
Date: Wed, 11 Feb 2026 09:53:58 +0100
Message-ID: <CANc5o7aqz7S=7msdLD=WS4MMWC-jEM76QQy6gU7xU39uJ2==rg@mail.gmail.com> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Access to pg_replication_origin* functions
  In-Reply-To: <CANc5o7aqz7S=7msdLD=WS4MMWC-jEM76QQy6gU7xU39uJ2==rg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox