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 |
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 |