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 1vWiot-008J5f-1V for pgsql-docs@arkaria.postgresql.org; Fri, 19 Dec 2025 22:19:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vWior-009DCw-0t for pgsql-docs@arkaria.postgresql.org; Fri, 19 Dec 2025 22:19:30 +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 1vWioq-009DCo-2w for pgsql-docs@lists.postgresql.org; Fri, 19 Dec 2025 22:19:29 +0000 Received: from mail-yx1-xb129.google.com ([2607:f8b0:4864:20::b129]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vWiop-001ZeC-2C for pgsql-docs@lists.postgresql.org; Fri, 19 Dec 2025 22:19:28 +0000 Received: by mail-yx1-xb129.google.com with SMTP id 956f58d0204a3-64471fcdef0so1764230d50.1 for ; Fri, 19 Dec 2025 14:19:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=xzilla-net.20230601.gappssmtp.com; s=20230601; t=1766182766; x=1766787566; darn=lists.postgresql.org; 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=gFtQVQbMMjmYNGXJ+AaAGztbUOJRNf0fOv6C4/GUcjY=; b=o1cCsZTpF0zHfoNrTozMo7WEY0wo3M7ZUWwmcvk6XSUmoRP4Gp9CWnvNpgo9tCpDxq 5vgETeI8IJCNv7TxdYvnk617Fh9pIa4swONeLVO4Lq/Fuj29kzBH2MgCb6DnI5NkCMF3 1dsWmrSX4Cc+gJZ9/nuCytYTT9lc7gl+Rcqonkt5lDxgsU2TL8vQ9qP3rClOOx50QBTr Qf4QUPbsR8MUDk7pf+thdxc3eM+rwRJ6WQkLMg296q7/lQtL9tKxbrLGXvYe9WqGUjsT f4EQCM3woTVnB9fVgtLUInJyZnZXhJoJT6ms6Wv5t5MPTBwflbiQ+Lb+F3jnjXWyvPR0 4ExA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1766182766; x=1766787566; h=content-transfer-encoding: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; bh=gFtQVQbMMjmYNGXJ+AaAGztbUOJRNf0fOv6C4/GUcjY=; b=IRaOqJG73GjotOwEOQRVwLi+yfc1gOl015nAPqqrjePETZspEO9DsTTJh6AWD6vEXy gyrRhhFV+xyAHyS9WSSgX1tCAMQdCYAMMXcFMQhiGAAfweHTflAUN/PMAVpCFhC28rQ1 Gc21D0KJZmu+oniPzWMnufmwQMvB8rdq7aUaOTp9LUs6U4ryGjraqqza7K1WzcGdEyV9 aVS2/XNSdepgWuF2Ji+lFrl+jAyj9xIlof0LY3JoEvjbUWkAELcuaPj27JRlKS5Xh/Gz qNestrme0Azf2z/DVd3MKL1ICae3/wI37p7uwDkJfF86Y3W2UkvOkJXFBsnHi8O+tiYa taRg== X-Forwarded-Encrypted: i=1; AJvYcCWPaq/Y6s0jjac8p0dK3mqDNugE8BGTZCr5vVnNa2Kzvwh8w9xpXfijsiV1S3cu8JhZU+g/1z70/pOw@lists.postgresql.org X-Gm-Message-State: AOJu0YyZ6IKwIr1F+8o0nwPnSZYOriYgM1lZVYxL60XDTa6PjuueGXyW C299iIYOX7Y0EPSHd025Yv2LR7W3cwyNzqCgvjFEMXXp7HpNVUHpHaOCxzHSfES42O+wx0A/L6k DVEgDZzRFYQZdL87l9MK3Oi5RqEMUsawB4wcvEtdMrQ== X-Gm-Gg: AY/fxX5Yyo8dU7lTpiZoMQbQJeqdbfAbRkw7vEg3reHo6XbVKHvA2F4l6NUtC0HDV3v aW7RZH/TMpdK1BAH2pJNo5IOD0ho1lgl7N5aWPxnotrPbcPuCUcEIKFJWyIWRChm81ayWR5J/oG vGKEoGaVfoiwztmCVb8rPnnMWUFXi0Vwj+o39NF1oBYEYluKgAdLt+9CunA1RUPsW9MbWtFBwOf /b8UdruRUsWkZdgOjeRXk9TP+wswYl6X0os/OtIT6II1qCXFfDgTaTdC7Q7rvOXl5C5UI8= X-Google-Smtp-Source: AGHT+IFUgdrDoubUxhEOPT+SN0i/GXWo2jLhq9g6kouahj4eZOYcGRfAt0xrpMyGOv7c1TJJva98Ge5ep1/Hfu1qYlo= X-Received: by 2002:a05:690c:3803:b0:78f:984b:4bb5 with SMTP id 00721157ae682-78fb40c5f09mr71567537b3.64.1766182766553; Fri, 19 Dec 2025 14:19:26 -0800 (PST) MIME-Version: 1.0 References: <2c392993640661b817c5c779f6aaf44c103510bf.camel@cybertec.at> In-Reply-To: From: Robert Treat Date: Fri, 19 Dec 2025 17:19:15 -0500 X-Gm-Features: AQt7F2rlqFGn5RqEWWh6cIJy3WGrhkOx-BvdyMRfmX8ESE9WojGCFThnKXufoUg Message-ID: Subject: Re: Streaming Replication vs Logical To: Bruce Momjian Cc: Paul A Jungwirth , Laurenz Albe , pgsql-docs@lists.postgresql.org 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 Fri, Dec 19, 2025 at 12:02=E2=80=AFPM Bruce Momjian w= rote: > > On Thu, Nov 27, 2025 at 12:16:01AM -0500, Bruce Momjian wrote: > > On Mon, Nov 24, 2025 at 11:28:22PM -0500, Robert Treat wrote: > > > > I took a look through some of the replication slot stuff and ISTM t= hat it basically gets the streaming logical/physical replication distinctio= ns correct, and I *think* > > > > it gets the slot distinctions correct as well, but to the degree th= ere might be some issue there, I think it could be addressed separately. > > > > > > > > > > Hey Bruce, > > > > > > Your recent commit on this topic [1] reminded me of the patch from > > > earlier this year meant to address some other areas where we are > > > blurry about using streaming vs physical vs logical replication. I > > > think (I might possibly still be jet lagged) I have updated the > > > previous version of that patch against HEAD, attached, and bumping it > > > up for review. > > > > Funny you found this patch, and I was thinking about it recently also > > because of the fixes for physical vs logical replication. I will apply > > this patch after sufficient review time, thanks. > > Great, patch applied, and commitfest updated. I apologize this dropped > off my radar for so long. > Thanks Bruce / All! Robert Treat https://xzilla.net