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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tFIhe-00CMVZ-Bi
	for pgsql-general@arkaria.postgresql.org; Sun, 24 Nov 2024 19:55:30 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tFIhb-009Ne1-PR
	for pgsql-general@arkaria.postgresql.org; Sun, 24 Nov 2024 19:55:27 +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 <xof@thebuild.com>)
	id 1tFIhb-009Ndt-9u
	for pgsql-general@lists.postgresql.org; Sun, 24 Nov 2024 19:55:27 +0000
Received: from smtp85.ord1d.emailsrvr.com ([184.106.54.85])
	by makus.postgresql.org with esmtps  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <xof@thebuild.com>)
	id 1tFIhY-003Zvw-JR
	for pgsql-general@postgresql.org; Sun, 24 Nov 2024 19:55:25 +0000
X-Auth-ID: xof@thebuild.com
Received: by smtp11.relay.ord1d.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id 782F060070;
	Sun, 24 Nov 2024 14:55:23 -0500 (EST)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51\))
Subject: Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting
 Up Streaming Replication
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CANzqJaANutDZy-bRCC1Sf0X7=LtF2HHMBfk73_MmVyXBReL4=w@mail.gmail.com>
Date: Sun, 24 Nov 2024 11:54:52 -0800
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <60D0A828-451D-48B1-8A47-B246806A03E5@thebuild.com>
References: <CAD=40Z3Rvbx46SxYBBdLvgSObXCP+Firszz++rDTXmGX795D2Q@mail.gmail.com>
 <6c498f0e-64f9-449a-9b90-5cd72d00e2ef@aklaver.com>
 <CAD=40Z1wJ7mBej9=Yqfo_1m-eOV61E=s6yDjZSaTBESbGunBUA@mail.gmail.com>
 <2a7d96ac-83a7-4ddc-a3ce-9c637f2c1c76@aklaver.com>
 <CAD=40Z3prwhLAedetocCu3jFvHSBP44V6O9d6CXjvzLTw7eOUQ@mail.gmail.com>
 <CANzqJaACBw1=jCAxGwSeu7dh4UfD2KePcNqSOC3=WwzXrg0skQ@mail.gmail.com>
 <CAD=40Z3k2dgVidM3oYuMWsauHyKF9v-0i4nOfMXd917PtNiO_g@mail.gmail.com>
 <1FBD217B-06FE-48CF-AA58-F7ADEDA5ADD2@thebuild.com>
 <CANzqJaANutDZy-bRCC1Sf0X7=LtF2HHMBfk73_MmVyXBReL4=w@mail.gmail.com>
To: Ron Johnson <ronljohnsonjr@gmail.com>
X-Mailer: Apple Mail (2.3776.700.51)
X-Classification-ID: b3a51ce3-cf7b-43bd-b773-665deb909dcd-1-1
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/60D0A828-451D-48B1-8A47-B246806A03E5%40thebuild.com>
Precedence: bulk



> On Nov 24, 2024, at 09:15, Ron Johnson <ronljohnsonjr@gmail.com> =
wrote:
>=20
> Doesn't the existence of a replication slot force PG to retain WAL =
files when replication is broken?

It does.  I don't recall if the OP said that they were using a =
persistent replication slot or not; it's not as common with binary =
replication as with logical replication.