Re: Allow using replication origins in SQL level parallel sessions

On Thu, Sep 4, 2025 at 11:32 PM Emre Hasegeli <emre(at)hasegeli(dot)com> wrote:
>
> Replication origins is a useful feature for external replication
> systems to do conflict resolution in bi-directional replication. It's
> possible for the external systems to make use of this feature using
> the SQL functions pg_replication_origin_*().
>
> pg_replication_origin_session_setup() is the one to configure the
> current session. Currently, only a single version of this function is
> exposed that allows one replica origin to be used only by a single
> session. This limits the usefulness of this feature.
>
> The attached patch creates another variant of this function
> pg_replication_origin_session_setup(text, int). This allows the same
> replica origin to be used by parallel sessions the same way logical
> replication apply workers are using it.
>

We are already discussing the same feature in an email thread [1]. Can
you check that and share your inputs there?

[1] - https://www.postgresql.org/message-id/CAMPB6wfe4zLjJL8jiZV5kjjpwBM2%3DrTRme0UCL7Ra4L8MTVdOg%40mail.gmail.com

--
With Regards,
Amit Kapila.