MIME-Version: 1.0
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>
In-Reply-To: <1FBD217B-06FE-48CF-AA58-F7ADEDA5ADD2@thebuild.com>
From: Subhash Udata <subhashudata@gmail.com>
Date: Sun, 24 Nov 2024 22:46:21 +0530
Message-ID: <CAD=40Z33zWtPmCa5bhtJaQR26CR4bXxBkYKUE1MXZ5JDFv6Qsg@mail.gmail.com>
Subject: Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting
 Up Streaming Replication
To: Christophe Pettus <xof@thebuild.com>, Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>, pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001073480627abc7b4"
Archived-At: <https://www.postgresql.org/message-id/CAD%3D40Z33zWtPmCa5bhtJaQR26CR4bXxBkYKUE1MXZ5JDFv6Qsg%40mail.gmail.com>
Precedence: bulk

--0000000000001073480627abc7b4
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thank you, everyone, for your valuable clarifications and insights. Your
guidance has been incredibly helpful in addressing my concerns and
understanding the best approach to proceed.

I truly appreciate the time and effort you=E2=80=99ve taken to assist me.

On Sun, 24 Nov 2024 at 22:36, Christophe Pettus <xof@thebuild.com> wrote:

>
>
> > 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.

--0000000000001073480627abc7b4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><p>Thank you, everyone, for your valuable clarifications a=
nd insights. Your guidance has been incredibly helpful in addressing my con=
cerns and understanding the best approach to proceed.</p><p>I truly appreci=
ate the time and effort you=E2=80=99ve taken to assist me.</p></div><br><di=
v class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sun, 24 No=
v 2024 at 22:36, Christophe Pettus &lt;<a href=3D"mailto:xof@thebuild.com">=
xof@thebuild.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" =
style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pa=
dding-left:1ex"><br>
<br>
&gt; On Nov 24, 2024, at 09:03, Subhash Udata &lt;<a href=3D"mailto:subhash=
udata@gmail.com" target=3D"_blank">subhashudata@gmail.com</a>&gt; wrote:<br=
>
&gt; 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?<=
br>
<br>
Assuming that the standby has access to any WAL generated during the shutdo=
wn (either still in the primary&#39;s WAL directory, or via an archive usin=
g archive_command), yes.=C2=A0 If you are not using a WAL archive using arc=
hive_command, you will want to make sure your wal_keep_size parameter is se=
t high enough that required WAL segments aren&#39;t recycled during the sta=
ndby&#39;s downtime.</blockquote></div>

--0000000000001073480627abc7b4--