From: | shveta malik <shveta(dot)malik(at)gmail(dot)com> |
---|---|
To: | "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com> |
Cc: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>, "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, shveta malik <shveta(dot)malik(at)gmail(dot)com> |
Subject: | Re: Conflict detection for update_deleted in logical replication |
Date: | 2025-06-23 08:41:45 |
Message-ID: | CAJpy0uChWC4MLt_d8EwmKRrYKQYfVQKJrng4KVgktr5v25HP5w@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> Here is the V39 patch set which includes the following changes:
>
Few trivial comments:
1)
Currently we have this error and detail:
ERROR: Enabling retain_conflict_info requires "wal_level" >= "replica"
DETAIL: A replication slot must be created to retain conflict information.
Shall we change it to something like:
msg: "wal_level is insufficient to create slot required by retain_conflict_info"
hint: "wal_level must be set to replica or logical at server start"
2)
+ <para>
+ Note that commit timestamps and origin data are not preserved during the
+ upgrade. Consequently, even with
+ <link linkend="sql-createsubscription-params-with-retain-conflict-info"><literal>retain_conflict_info</literal></link>
+ enabled, the upgraded subscriber might be unable to detect conflicts or log
+ relevant commit timestamps and origins when applying changes from the
+ publisher occurring before or during the upgrade. To prevent this
issue, the
+ user must ensure that all potentially conflicting changes are fully
+ replicated to the subscriber before proceeding with the upgrade.
+ </para>
Shall we have a NOTE tag here? This page has existing NOTE and WARNING
tags for similar situations where we are advising something to users?
thanks
Shveta
From | Date | Subject | |
---|---|---|---|
Next Message | shveta malik | 2025-06-23 09:19:22 | Re: POC: enable logical decoding when wal_level = 'replica' without a server restart |
Previous Message | Anthonin Bonnefoy | 2025-06-23 08:40:36 | Improve doc on parallel stream changes for Stream Abort message |