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 1s4jA3-000ZsC-V4 for pgsql-general@arkaria.postgresql.org; Wed, 08 May 2024 15:24:52 +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 1s4jA1-001f6v-V5 for pgsql-general@arkaria.postgresql.org; Wed, 08 May 2024 15:24:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s4jA1-001f6n-HD for pgsql-general@lists.postgresql.org; Wed, 08 May 2024 15:24:49 +0000 Received: from mail-yb1-xb2b.google.com ([2607:f8b0:4864:20::b2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s4j9w-0002gD-KQ for pgsql-general@postgresql.org; Wed, 08 May 2024 15:24:49 +0000 Received: by mail-yb1-xb2b.google.com with SMTP id 3f1490d57ef6-deb654482bcso4642346276.1 for ; Wed, 08 May 2024 08:24:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=curvedental.com; s=google; t=1715181883; x=1715786683; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=3g9YSyy+60WEBQh+KxCWwoYxGTkwjdsdZmfDaaBpXVw=; b=U1pr6VhYK6dUFl9jwl3zw6mRfD9jqR5jbj/aIWI0i4QJlQRC81ywQswj/oJkAiPb+f yuKfGtXVALf094Cttm5d+gq/ueBnRwAY9GpYOLh6QUl5iHnnY3l4BJvoxiqITMR+sZ55 oFTdH/bbRRjHb894yPB8PaAOlu076CA4YFYZ8= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1715181883; x=1715786683; h=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=3g9YSyy+60WEBQh+KxCWwoYxGTkwjdsdZmfDaaBpXVw=; b=cUzhs7uSoZZL0svSBCWd4Cof/4cEib4WOkNmg3C7zMGOXKacdYk1JQL5wpnzvoE1jc EgyV9garUR03QSBJ0PCVxlkJaf3J/tOYeBwq6kYdest4T3jQw3gzLci5+bHF51nsYcN6 GL98l9MD83c2OC8l+7UQapG356gcAhb9cpk7JmIvuD9PkpnPjaCJ6RbUk0z5YE3KINd4 m3LAsusHcjh35QTtDGfJBpc7MEXfeUSbHxcog1WSsDCkbGuwFGBB7rUVPn4FJZCwlp9z dhlUmXfqP0FmkveC9WJw3k7H3zVqHwRDisQUBqV7NvyH3H/tHmuslmQK0/qixBtguYWm ro8g== X-Gm-Message-State: AOJu0YxIY3U6+pzNtRh2/r+iSmo3N7+SRTQLbrQFyspC2MT0K2Xozpke bPEsoAOdfUL1IcAK7prZvHUoO50Mn1/h+NSNhUw/m9KM7xHdHPqsB4/6oz7u491YudRyix7u+hW S+/ZYFYZpod8X93MFaj7dxgf4P/4cUh5uw/j8i8R5Vo0SspKddiSt X-Google-Smtp-Source: AGHT+IFXPq9u6Z0wqsKh/+dkmvdOs5smnKASEAntzjxGr62CNfOQ4udYNB8bxiolPlqfiwdIkfl0wAjmzq24EdGsGc8= X-Received: by 2002:a25:df86:0:b0:de5:5089:32b8 with SMTP id 3f1490d57ef6-debb9df4e8dmr2592984276.63.1715181883612; Wed, 08 May 2024 08:24:43 -0700 (PDT) MIME-Version: 1.0 References: <8a534c5f-e400-4bb5-b39e-2017d259ff06@aklaver.com> In-Reply-To: <8a534c5f-e400-4bb5-b39e-2017d259ff06@aklaver.com> From: Daniel McKenzie Date: Wed, 8 May 2024 16:24:32 +0100 Message-ID: Subject: Re: Unexpected data when subscribing to logical replication slot To: Adrian Klaver Cc: pgsql-general@postgresql.org Content-Type: multipart/alternative; boundary="000000000000e5fa6a0617f2e642" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e5fa6a0617f2e642 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable It's running both (in docker containers) and also quite a few more docker containers running various .NET applications. Daniel McKenzie Software Developer Office: +1 403.910.5927 x 251 Mobile: +44 7712 159045 Website: www.curvedental.com *Curve Dental Confidentiality Notice* This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged, confidential, or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy, or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by replying to this e-mail and delete all copies of this message. On Wed, May 8, 2024 at 4:17=E2=80=AFPM Adrian Klaver wrote: > > > > > We have found two things that appear to resolve the problem - > > > > * Using a more powerful EC2 instance. We can reproduce the issue with > > a r7a.medium instance but not with a r7a.large EC2 instance. > > * Changing the Postgres synchronous_commit parameter from "on" to > > "off". We cannot reproduce the issue with synchronous_commit set to > > "off". > > What is running on the EC2 instance?: > > 1) The Postgres server. > > 2) The replication receiver. > > 3) Both. > > > > > > We need help to understand this unexpected behaviour. > > > > We are using Postgres 14.10. > > > > Thanks, > > Daniel McKenzie > > -- > Adrian Klaver > adrian.klaver@aklaver.com > > --000000000000e5fa6a0617f2e642 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
It's running both (in docker containers) and also= quite a few more docker containers running various .NET applications.

Daniel McKenzie
Software = Developer

Office: +1 403.910.5927 x 251
Mobile: +44 7712 159045
Website:=C2=A0www.curvedental.com

Curve Dental Confidentiality Notice
This message is intended exclusively for the individual or e= ntity to which it is addressed. This communication may=C2=A0contain information that is proprietary, privileg= ed, confidential, or otherwise legally exempt from disclosure. If you are= =C2=A0not the named addressee, you= are not authorized to read, print, retain, copy, or disseminate this messa= ge or any=C2=A0part of it. If you = have received this message in error, please notify the sender immediately b= y replying to this e-mail=C2=A0and= delete all copies of this message.


On Wed, May 8, 2024 at 4:17=E2=80=AFPM Adrian Klaver <adrian.klaver@aklaver.c= om> wrote:
adrian.klave= r@aklaver.com

--000000000000e5fa6a0617f2e642--