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 1vJv6r-008CAW-1r for pgsql-committers@arkaria.postgresql.org; Fri, 14 Nov 2025 14:49:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vJv6p-006lLa-0I for pgsql-committers@arkaria.postgresql.org; Fri, 14 Nov 2025 14:49:07 +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.96) (envelope-from ) id 1vJv6o-006lLS-2m for pgsql-committers@lists.postgresql.org; Fri, 14 Nov 2025 14:49:06 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vJv6m-007jWz-1w for pgsql-committers@lists.postgresql.org; Fri, 14 Nov 2025 14:49:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2025010100; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID: Subject:Cc:To:From:Date:Sender:Reply-To:Content-Transfer-Encoding:Content-ID: Content-Description; bh=0nPRp+HmPtPsP3bnJQpIy0iKkFxgGeZk75qA476ZH0U=; b=bRRBr yeDnd65ToqUzQVTsfuqRN4u0wwa0UqBxfPLrLfvjgWOx7WdWnBjCZzQ2NWV/P9ybCqWOaN1ZfqQhi dqdBvyRaAJTw8pVxaWFlE0B0R/HdCNIQbexdWchEsr/o9+ergzG5UvpdH2sef7GOzNJ+aB8MfC+xW gTFIXXY0D2+RemfqNJ+gc1X7RhH6Wy/fl2VIiQTANpLGASHxOPAoviud3jAsi+Dzuvpm9D4Nt/fGt vKYwM0q9g5fADcgyAuF78YAUdKcaqrYioNxlhbT3hjkwC/KGnb/Uc7PKrTRSf6fo+jy56m6edA+xg gNuhXQqlNO8es2tGEPhp6fYErRmjw==; Received: from bruce by momjian.us with local (Exim 4.98.2) (envelope-from ) id 1vJv6k-0000000Ff0D-3caN; Fri, 14 Nov 2025 09:49:02 -0500 Date: Fri, 14 Nov 2025 09:49:02 -0500 From: Bruce Momjian To: Andres Freund Cc: pgsql-committers@lists.postgresql.org Subject: Re: pgsql: doc: remove verbiage about "receiving" data from rep. slots Message-ID: References: <53n63x724ahx2nwx42bmivjlt67fpbyh44knx7jazodsqcs5av@umzjyyg3clpq> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="hbCB490QvwoTBhRH" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --hbCB490QvwoTBhRH Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, Nov 14, 2025 at 09:25:20AM -0500, Andres Freund wrote: > Hi, > > On 2025-11-14 09:12:33 -0500, Bruce Momjian wrote: > > On Fri, Nov 14, 2025 at 09:05:07AM -0500, Andres Freund wrote: > > > Hi, > > > > > > On 2025-11-14 09:02:12 -0500, Andres Freund wrote: > > > > On 2025-11-14 13:56:06 +0000, Bruce Momjian wrote: > > > > > doc: remove verbiage about "receiving" data from rep. slots > > > > > > > > > > The slots are just LSN markers, not something to receive from. > > > > > > > > I think this is wrong. Logical slots also preserve resources other than WAL. > > > > > > I also think that the complaint about slots not being something to receive > > > from is simply wrong for logical slots. > > > > Uh, can you clarify since I can't find details on what they preserve. > > Slots (physical ones can, logical ones always do), prevent row cleanup on the > primary. I see your point. How is the attached patch? The link right after the modified text talks only about WAL retention, so I think we need something in this sentence to say we do more than WAL retention for logical replication slots. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Do not let urgent matters crowd out time for investment in the future. --hbCB490QvwoTBhRH Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="slot.diff" diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml index 8a9674bd6d1..aa013f348d4 100644 --- a/doc/src/sgml/logical-replication.sgml +++ b/doc/src/sgml/logical-replication.sgml @@ -225,8 +225,9 @@ - By default a new subscription creates a logical replication slot on the - publisher and then uses this slot to preserve necessary WAL (see ). Additional replication slots may be required for the initial data synchronization of pre-existing table data and those will be dropped at the end of data --hbCB490QvwoTBhRH--