Allow using replication origins in SQL level parallel sessions

From: Emre Hasegeli <emre(at)hasegeli(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Allow using replication origins in SQL level parallel sessions
Date: 2025-09-04 18:02:02
Message-ID: CAE2gYzyTSNvHY1+iWUwykaLETSuAZsCWyryokjP6rG46ZvRgQA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

I'll add this to the next commitfest.

Attachment Content-Type Size
v00-pg_replication_origin_session_setup_acquired_by.patch application/octet-stream 4.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2025-09-04 18:15:21 Re: POC: enable logical decoding when wal_level = 'replica' without a server restart
Previous Message Sami Imseih 2025-09-04 17:56:46 Re: PgStat_HashKey padding issue when passed by reference