Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pFUCl-0000aF-BH for pgsql-bugs@arkaria.postgresql.org; Wed, 11 Jan 2023 06:03:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pFUCj-0002lS-8r for pgsql-bugs@arkaria.postgresql.org; Wed, 11 Jan 2023 06:03:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pFUCj-0002k7-0Y for pgsql-bugs@lists.postgresql.org; Wed, 11 Jan 2023 06:03:17 +0000 Received: from mail-oa1-x2c.google.com ([2001:4860:4864:20::2c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pFUCg-0000U1-S4 for pgsql-bugs@lists.postgresql.org; Wed, 11 Jan 2023 06:03:15 +0000 Received: by mail-oa1-x2c.google.com with SMTP id 586e51a60fabf-1322d768ba7so14540486fac.5 for ; Tue, 10 Jan 2023 22:03:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=sW0BWZU1GzuX1AbYud7K2afqUwT4xB4i7AoBhGxyQq0=; b=c8MVDyOoFOp+M/5cyEjjHxLUCTvGbXkW6bPyQdsP5Oi7w+ajvOrC5dAoWuS39fOisg 0oTGSBP8tyK+Q/jiUkaqmo03MFigN79DPBR/NcGNToM/zszy+EM8lvgNwbV5NPPA6oGM JyKHMv3BrvRCvEXyFQwYAYsqpL4m9Hx8CVH3/dK9FAik59F5Am0L0xvX9fT26EjGBN/i OJonTIFM1YL9i0Etfmd3wi+rGnJaGq+yHPhwXsSs8C/0p2uuGbma1FvDgrP4MzRy/oRr Rrkbkb5uHsti2Vy599biHoGSgF6NlOSYQecm8bYTqRZCl6pn/07sD7lxNCAVjKDrmWK+ TlEw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=sW0BWZU1GzuX1AbYud7K2afqUwT4xB4i7AoBhGxyQq0=; b=ADLDSB2EJAn0SX0GG9UnJG0qj/ihV261lQ4JTlzS72rqNKOT4iBBSlHt9hFW5jUy5r 4GtfUp/JfW6khJ3ULcvztJoT3dN2DcGhTBlzOSlm5aHuMVUbaAgLkIyWiBGRTfyTQqfr IKD/ZrXfhlpuwBxyQYULZxE7UA5k/J9HVlafDLJho/OF21LkW4Z2OdoEOaDcAeYZyfhB XAP/R4UVsP9eSc74/cSaf/r76PQNDCdlYJd+QR+/spU3i1wwlzjnBskLAC8GDlJ6bspg u3ThTDk7nF9o4M/dpRjjFSb9fUtSVX8zZPQYuJtXoe5jrdseHUWfeTWOh8D0VSGZQVPm X8uQ== X-Gm-Message-State: AFqh2ko3hkC+KLo3ajYaCgFdnCqBdOKATwdyD4vq5KZJfSCzU1fVMhvt 1RDAF9lMppWG8dZodwA5Ngm+uCZlHaDEioVaKYsfTOgS X-Google-Smtp-Source: AMrXdXts7GfgtIdaAikWiu7leKLGyoTTmYBQszlUPNOa0KrGLjVkrn53lILKd31D7MKQ1EbhQHRRbWprL3dICUV29SA= X-Received: by 2002:a05:6870:9d05:b0:14f:e7f3:4ccc with SMTP id pp5-20020a0568709d0500b0014fe7f34cccmr4498255oab.261.1673416993987; Tue, 10 Jan 2023 22:03:13 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Amit Kapila Date: Wed, 11 Jan 2023 11:33:02 +0530 Message-ID: Subject: Re: pg_logical_slot_peek_changes with slots created with pglogical_output missed DML records, To: "James Pang (chaolpan)" Cc: PostgreSQL mailing lists 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 Tue, Jan 10, 2023 at 7:12 PM James Pang (chaolpan) wrote: > > Hi, > > We test pglogical replication, with pglogical.conflict_resolution=3Der= ror, and from source database run > > Insert into pgbench_branches values(109,0,=E2=80=99test=E2=80=99); > > Commit; > Can you reproduce this with native logical replication? Otherwise, it may be better to report this on pglogical mailing list. --=20 With Regards, Amit Kapila.