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: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sun, 24 Nov 2024 12:15:27 -0500
Message-ID: <CANzqJaANutDZy-bRCC1Sf0X7=LtF2HHMBfk73_MmVyXBReL4=w@mail.gmail.com>
Subject: Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting
 Up Streaming Replication
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ce727c0627abc35b"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaANutDZy-bRCC1Sf0X7%3DLtF2HHMBfk73_MmVyXBReL4%3Dw%40mail.gmail.com>
Precedence: bulk

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

On Sun, Nov 24, 2024 at 12:06=E2=80=AFPM Christophe Pettus <xof@thebuild.co=
m> 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.


Doesn't the existence of a replication slot force PG to retain WAL files
when replication is broken?

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Sun, Nov 24, 2024 at 12:06=E2=80=AFPM =
Christophe Pettus &lt;<a href=3D"mailto:xof@thebuild.com">xof@thebuild.com<=
/a>&gt; wrote:</div><div class=3D"gmail_quote"><blockquote class=3D"gmail_q=
uote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,2=
04);padding-left:1ex">&gt; On Nov 24, 2024, at 09:03, Subhash Udata &lt;<a =
href=3D"mailto:subhashudata@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><div><br clear=3D"all"></div><div>Do=
esn&#39;t the existence of a replication slot force PG to retain WAL files =
when replication is broken?</div><div><br></div><span class=3D"gmail_signat=
ure_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div d=
ir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil =
me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div>=
</div></div></div></div>

--000000000000ce727c0627abc35b--