Re: Proposal: Conflict log history table for Logical Replication
Peter Smith <smithpb2250@gmail.com>
From: Peter Smith <smithpb2250@gmail.com>
To: Dilip Kumar <dilipbalaut@gmail.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>,
shveta malik <shveta.malik@gmail.com>, vignesh C <vignesh21@gmail.com>, Masahiko Sawada <sawada.mshk@gmail.com>, Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-01-19T04:11:59Z
Lists: pgsql-hackers
Some review comments for v22-0003. ====== 1. It looks like none of my previous v20-0003 review comments [1] have been addressed. Maybe accidentally overlooked? ====== 2. + <caution> + <para> + The internal conflict logging table is strictly tied to the lifecycle of the + subscription or the <literal>conflict_log_destination</literal> setting. If + the subscription is dropped, or if the destination is changed to + <literal>log</literal>, the table and all its recorded conflict data are + <emphasis>permanently deleted</emphasis>. To perform a post-mortem analysis + after removing a subscription, users must manually back up or rename the + conflict table before the deletion occurs. + </para> + </caution> 2a. Let's consistently call this the "Conflict log table", same as everywhere else, not "logging table". ~ 2b. This is only a caution for the CLT, so I felt it's better to put this in the scope of the 'table' param value. ~~~ 3. + analysis of conflicts. This table is automatically dropped when the + subscription is removed. If you move the <caution> to this scope, as suggested above in #2b, then you can remove the sentence "This table is automatically dropped when the subscription is removed", because that is duplicate information you already wrote in the caution. ====== [1] v20 docs review - https://www.postgresql.org/message-id/CAHut%2BPuzB4gNYvqX9hb28KE0RK_xhU%2B2-%3DwUfL5OEVUCi92Hqw%40mail.gmail.com Kind Regards, Peter Smith. Fujitsu Australia
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Allow logical replication conflicts to be logged to a table.
- a5918fddf10d master landed
-
Avoid orphaned objects dependencies
- 2fbb21170e90 19 (unreleased) cited