Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1whnb1-000QYT-1J for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Jul 2026 12:11:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1whnay-00CuRc-1R for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Jul 2026 12:11:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1whnax-00CuRT-2d for pgsql-hackers@lists.postgresql.org; Thu, 09 Jul 2026 12:11:12 +0000 Received: from mail-pf1-x434.google.com ([2607:f8b0:4864:20::434]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1whnaw-00000000JYD-1eXh for pgsql-hackers@lists.postgresql.org; Thu, 09 Jul 2026 12:11:11 +0000 Received: by mail-pf1-x434.google.com with SMTP id d2e1a72fcca58-8423f236418so1265641b3a.1 for ; Thu, 09 Jul 2026 05:11:10 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1783599070; cv=none; d=google.com; s=arc-20260327; b=fB+NAy+UC8i0Zm8ELvjyNRMlnNu/aJGL7hhkczudn8N2pUiqj+hg1Udm+xTBbz2rr0 cBj2kTnCT8KbSbpjSCBKrFMJ8rMzelip2iTaKI4p/5fkkhmoQxTNAxwfo57jmeZlKqJf w6/y3lHvtnFFpGYuWYeCeKZqKCaP/l5ahDBhuazl4nOe7+U8YIeboc2zrmmYksidRuEh Wpobtx2DFHczKdummy/D2Nv9FlKdOWUCcmGplxAphY7ooCI5AsOWxeHPusjowaL5XjtO BUjQPptUtn8tDtoLgh0Y+iT25qfRnqylOa/IuRSklx6Z++9v64gPcU/mXYH0kk4JLrUf pOzw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20260327; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=NKQrgXBS1xaMal01S0t6Tb0L1ASvvATDpXAQjKqZa50=; fh=mYKRE2fSZKflecTjn1Fd543QZHMhKXAUu4YJW/GiWcs=; b=dLTIF3JOyIUZtsaXGvC97NNi02x2qj9Vea32DiyhpolGwVwwVFZj7q5VheIAg/svLZ 1ffzJ287nKTmaJUYrxwag24TY/po+aEL1ZewNiuyQwJdh5xd5+eXU2yKNaaBVOUJxp/B N6kU0ke2xRdd4tRgT+8RMR7dWsYbUbmywF1SwgT9JSP12JgYtn+poFgYiAX5o7LYZyz3 E+zi75LXPRfo9hvfmZEtIYfgN+TmOTR2Mfz0J89AzsY2P4vfOETZtT9ZPQa6fogLfk13 3dE5SqVGp4bvqA/6CMi2B5rmiimuTb5K8kikaHnnzUuFXVq7APE7MfQ0ecD7abnOvS2Q ac0g==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1783599070; x=1784203870; darn=lists.postgresql.org; h=content-transfer-encoding:content-type:cc:to:subject:message-id :date:from:in-reply-to:references:mime-version:from:to:cc:subject :date:message-id:reply-to:content-type; bh=NKQrgXBS1xaMal01S0t6Tb0L1ASvvATDpXAQjKqZa50=; b=axznrJZSC4NY2Kk6UtQohIq+cweeaH6sfiyPuAjK2w/5M0tSuRndhxRJndu5HlLLK2 fUup4HoYPjg17xxXFzjLU69EttY9HZcYCq1SUIYrsfQiSYnCOGAv7X5EAvS3Iw2qbSt/ PhBAj9IqAu2creVjo2hCMENR66NGyiIdhGNAJDR2Tl6mnt34Ed7GIZnRVvyM15OOOCY1 jU2izfNbL6uC+QoXqU3MYsLDp285fOZCHCamFnASenKdchSf+yckN9F2H1Xl+Ggmwr63 PweyXqRXD6ADUasA+Inasidx3L82g0Q6TamAix9sgdbavFbAmdYr8Oq3GCpBNqdbgpze gBdw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1783599070; x=1784203870; h=content-transfer-encoding:content-type:cc:to:subject:message-id :date:from:in-reply-to:references:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=NKQrgXBS1xaMal01S0t6Tb0L1ASvvATDpXAQjKqZa50=; b=OeKtsktzsB0WrKUalscgv5QTuLK/WQu5vTDanmTKpancsU9s+VKjkA6WkbfE/x2oud lHjMN+eR2jQmf2FN6W03oFwkAndjNTcRgzWldPuPITPZIy/U9oQFoFP6Dcfvx3/6X+d1 lGJt/pNNOgL3GBDDh6jvK8KREYXKI6SKasQd2jktjGXo6UTUCGY+wan3vIXRBt3U3134 Xd/6R2qyLO2cR8snDvlv/NtdnImADsSO6xMQKt/oZ732hOVywlyLR3UWXtuTpaamtjTz U5QcbDcPF/4WHX50LXDI0bw8icBdA5X+O/ShSfJGqmapvD8gA2wtddJXvsedwiZ683oO F0oQ== X-Forwarded-Encrypted: i=1; AHgh+RqkhtFIWyuAT6oGicpUmy9JUreJXsGPgJGJrr6NATK0NTxHrCJ7TdjeF1UWEsOVRNwy7lu5CfA4WHi1Uu2+@lists.postgresql.org X-Gm-Message-State: AOJu0YzW1+XC+S/yH0J5NFgxXliFGVxCzAs13yaxizXfAm9/VKT8RN3N b7rdL0f2QGj8y/WJVKtNCrR0wke7pl9JQb1uB2oc7u3vgj7A3OTP3NZkNNtlcOXHHVYYvU6VX5D gFXDS5bg0IQuQl9buEFNUaPk8pVSp1/E= X-Gm-Gg: AfdE7clN+tSUu9LKkDdhD08OzeEl18KWRy9tK8OhyOLQRsiphQaBCfC/MYUnky8kGto JM0XQVfAUWDdccMFQ/neZIrTNxbGIoOA+6whAqmfFhfiARfQHia/xetX9eJmDL/dU26Kbk0u4GD SDpD9kRbSVXNlm+mk3v4hUy/sOeFOwzq5C1KR31i6N9olSDzZgUPIrh1BaDnS6dOiW3IDpvpblF 4zN4T/lRj0MoVdigcYHINKt1Ag3bLM+IdW0RR9QrMbWJqRCrlkHvlBgJKYiqlC1nDqkdvOvQHdN Fky4xQfS7N97Pi+4UuM1YKVex20ibB2imPWeDfXx X-Received: by 2002:a05:6a00:1826:b0:845:d274:c024 with SMTP id d2e1a72fcca58-84843689f99mr5927113b3a.61.1783599069576; Thu, 09 Jul 2026 05:11:09 -0700 (PDT) MIME-Version: 1.0 References: From: shveta malik Date: Thu, 9 Jul 2026 17:40:57 +0530 X-Gm-Features: AVVi8CfYuJt7HVwHJfKhsbBqUrxoNHfe5E_x7l5XkSxuxDGE_rFW_BvSEI-ANbE Message-ID: Subject: Re: Proposal: Conflict log history table for Logical Replication To: Kedar Anavardekar Cc: Dilip Kumar , Amit Kapila , Peter Smith , vignesh C , Nisha Moond , Masahiko Sawada , Bharath Rupireddy , PostgreSQL Hackers , shveta malik Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jul 9, 2026 at 5:11=E2=80=AFPM Kedar Anavardekar wrote: > > > I rebased the remaining patches on top of HEAD. So far, I have run > > pgindent and completed the doc merge for 0001. The 0002 and 0003 are > > just rebased. > > > > Hi Dilip, > > I was testing on the master branch (commit > a5918fddf10d297c70f7ec9067e9177e0be6d520 - > "Allow logical replication conflicts to be logged to a table") for > basic CLT operations, > and ran into an issue I'd like to check with you. > I ran the SQL from the shell script and expected an insert conflict to > get logged in the CLT. I created the subscription as follows: > > create subscription sub connection '...' publication pub > WITH(conflict_log_destination=3D'table'); > NOTICE: created conflict log table > "pg_conflict.pg_conflict_log_16414" for subscription "sub" > NOTICE: created replication slot "sub" on publisher > CREATE SUBSCRIPTION > > However, I noticed that the conflicts are still being logged to the > log file rather than to pg_conflict.pg_conflict_log_16414. > > Would you be able to let me know if my test setup was correct, or if > I'm missing a step somewhere? Any pointers would be much appreciated. > The concerned commit only creates the infrastructure required for conflict logging, it does not enable conflict logging yet. Please see the last paragraph of the commit message: "This commit only establishes the conflict log table along with its creation, cleanup, and protection; recording the conflicts detected during apply into the table will be handled in a follow-up commit." The patch for conflict insertion is in progress in this thread. See v64 attached in [1]. [1]: https://www.postgresql.org/message-id/CAFiTN-vLKRRSDMwPGMvcBM1CRntXbsH= ARU-0e76PDk%3D-k5RO6A%40mail.gmail.com thanks Shveta