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.94.2) (envelope-from ) id 1taD3C-00HKUl-4p for pgsql-general@arkaria.postgresql.org; Tue, 21 Jan 2025 12:08:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1taD3A-00FfCV-RT for pgsql-general@arkaria.postgresql.org; Tue, 21 Jan 2025 12:08:08 +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.94.2) (envelope-from ) id 1taD3A-00FfCL-Eb for pgsql-general@lists.postgresql.org; Tue, 21 Jan 2025 12:08:08 +0000 Received: from mail-ej1-x636.google.com ([2a00:1450:4864:20::636]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1taD38-000j97-05 for pgsql-general@lists.postgresql.org; Tue, 21 Jan 2025 12:08:07 +0000 Received: by mail-ej1-x636.google.com with SMTP id a640c23a62f3a-aa69107179cso1050887166b.0 for ; Tue, 21 Jan 2025 04:08:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1737461284; x=1738066084; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=l55a9E1AisDHgPp67FLtTqWgH9tBlK4iKLhDcNXQzhs=; b=bp6jXm/NSL+pq3dQzp/aBMD2s1g1+ytORtZcZnrTq4YIED6INN0vkAbd8gTlMeEB+r D4Y3oTLirqcIu9/onT49p/MLxjhkmqWiY+lD7wbQNso5GWHEBsOTl2dZQuvqJfpdDpHB 8iD/tbOuWfDjWJxTXMLcy+N7Qyj7diH+4EIqTDe6KiOPRSvSnHxsTPk0A8Nymw6Trdtw MPitOKob8qb9Dk455VdT68h7PlWSZR3gdEHGGIrEV2df1VUL2gQrJJR9xDm+x5XvN5xG EreMpXd/Y3/AuxRAo+8xbqLsfShPQ9XyxclxAH0Y4+Fy1Vt9R+XWc0axtlIv+RVPVCvQ k2nw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1737461284; x=1738066084; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=l55a9E1AisDHgPp67FLtTqWgH9tBlK4iKLhDcNXQzhs=; b=GoYDRrGMdHi07STDeGK2PRS3U7N1P1Oio+Hbmb4yi+DZmpsLrJT3ts2AQrYoTHhYIx qrMC15C2JBGgka5Mk1gCCYORzGd4qKYFJ5Ng98tc/mW0bTHsaKQ8nramEWRqrlIGOteq iKvP6wjvxruQL9CiDewtYc845Rlg8JtKUgXJ0jknIDMSLAZD5qR+j6qDQVtRPyCedLL7 OtIXJtqr5thWemBzSx5/xsPy+3DCnN7X5PWkn46XyVHawuZJrZxYsfjy2cVkEhr+PV8l cj1fvCf/r6Ynyc1TMvBvDN8LrFzvYxcRS03DzqGnGRwwDSJjmNAy3BohQRnv/jlQ5xj3 CrAg== X-Gm-Message-State: AOJu0YzKbrqyKUsTYK1HpA76MW1CvfWOKviH8BcCXtNembp5rXYPB195 2AIAPcMjZStSGHNMDEXUp2OD5VF9URQ+TWZw9/QtqZWvOb0a4KeRv5F6Wy878V5mjJnk6R8xHud 6ZuC58q6oafcDfgJ9uaEFdcNYPuEAsGUi X-Gm-Gg: ASbGncuDuE3jIjuJFjt8WGbBnL8vdXcZ9fBk1CUbr/JjZUyFoyhkViSwBPWWnzjirzD uJjMFDuXlFWShrFav2gZkFqPkllTwO053jmKyBl9zAqjhnvgQGOA= X-Google-Smtp-Source: AGHT+IHEG2mXOWZdXRnJG5Nh/9dtFxvKKy+/2w3Wei2iwZqVm3ivPorVgs1khncm/+ITKvpQjcNKLU63AypkRZ84VGQ= X-Received: by 2002:a17:907:1c26:b0:aab:9361:f8f8 with SMTP id a640c23a62f3a-ab38b3cdfa1mr1513459966b.50.1737461284234; Tue, 21 Jan 2025 04:08:04 -0800 (PST) MIME-Version: 1.0 From: Durgamahesh Manne Date: Tue, 21 Jan 2025 17:38:38 +0530 X-Gm-Features: AbW1kvb3ZZlO3Ykbuhgh1H-r9OKC4eqpIt6IFbv5seEWJ8HXQkvw6jnXRZgzhX0 Message-ID: Subject: Records count mismatch with logical replication To: pgsql-general Content-Type: multipart/alternative; boundary="000000000000a86f42062c363aa5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a86f42062c363aa5 Content-Type: text/plain; charset="UTF-8" Hi Team, I have publication and subscription servers .So seems data replication running with minimal lag but records count mismatch with more than 10 thousand records between source and destination tables Could you please help in resolving this issue? Regards, Durga Mahesh --000000000000a86f42062c363aa5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0 Team,

I have publication and s= ubscription servers .So seems data replication running with minimal lag but= records count mismatch=C2=A0with more than 10 thousand=C2=A0records betwee= n source and destination tables=C2=A0

Could you pl= ease help in resolving this=C2=A0issue?

Regards,
Durga Mahesh=C2=A0



--000000000000a86f42062c363aa5--