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: <CAD=40Z3k2dgVidM3oYuMWsauHyKF9v-0i4nOfMXd917PtNiO_g@mail.gmail.com>
Date: Sun, 24 Nov 2024 09:06:09 -0800
Cc: Ron Johnson <ronljohnsonjr@gmail.com>,
 pgsql-general <pgsql-general@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <1FBD217B-06FE-48CF-AA58-F7ADEDA5ADD2@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>
To: Subhash Udata <subhashudata@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/1FBD217B-06FE-48CF-AA58-F7ADEDA5ADD2%40thebuild.com>
Precedence: bulk


> On Nov 24, 2024, at 09:03, Subhash Udata <subhashudata@gmail.com> =
wrote:
> When we shut down the standby, upgrade it, and then start it back up, =
will the replication automatically resume from the primary to the =
standby?

Assuming that the standby has access to any WAL generated during the =
shutdown (either still in the primary's WAL directory, or via an archive =
using archive_command), yes.  If you are not using a WAL archive using =
archive_command, you will want to make sure your wal_keep_size parameter =
is set high enough that required WAL segments aren't recycled during the =
standby's downtime.=