Allow using replication origins in SQL level parallel sessions
Emre Hasegeli <emre@hasegeli.com>
From: Emre Hasegeli <emre@hasegeli.com>
To: pgsql-hackers@postgresql.org
Date: 2025-09-04T18:02:02Z
Lists: pgsql-hackers
Attachments
- v00-pg_replication_origin_session_setup_acquired_by.patch (application/octet-stream) patch v0
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.
Commits
-
Add optional pid parameter to pg_replication_origin_session_setup().
- 5b148706c5c8 19 (unreleased) landed