Access to pg_replication_origin* functions

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

Browse pgsql-general by date

  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