MIME-Version: 1.0
References: 
 <CAL5GnisA0RJ=Rd5e6yw4nsCB+DtAS1=iquBKTH76MknnTsHrPg@mail.gmail.com>
 <CANzqJaA1VyGqPUQaeT9vfxNV1C3rQJSdMHa9xtzx+rJQhkY2gw@mail.gmail.com>
In-Reply-To: 
 <CANzqJaA1VyGqPUQaeT9vfxNV1C3rQJSdMHa9xtzx+rJQhkY2gw@mail.gmail.com>
From: Motog Plus <mplus7535@gmail.com>
Date: Mon, 18 Nov 2024 22:49:54 +0530
Message-ID: 
 <CAL5Gnitdyw7vCp4-0whmmJ-RC7Z9yQVx=xrtfQO6-Lxcfvqrqw@mail.gmail.com>
Subject: Re: Guidance Needed for PostgreSQL Upgrade from 12 to 15
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e4442d0627332020"
Archived-At: 
 <https://www.postgresql.org/message-id/CAL5Gnitdyw7vCp4-0whmmJ-RC7Z9yQVx%3DxrtfQO6-Lxcfvqrqw%40mail.gmail.com>
Precedence: bulk

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

Thanks Ron for your suggestion.
So for pg upgrade in streaming replication setup, rsync will be a better
option for standby upgrade if we are using --link option or recreating the
standby, once upgrade completes on primary? Any suggestions on this please.

Best Regards,
Raman


On Mon, Nov 18, 2024, 22:41 Ron Johnson <ronljohnsonjr@gmail.com> wrote:

> On Mon, Nov 18, 2024 at 11:08=E2=80=AFAM Motog Plus <mplus7535@gmail.com>=
 wrote:
>
>> Dear Team,
>>
>> We are in the process of upgrading our PostgreSQL database from version
>> 12 to version 15. I would greatly appreciate your advice on the followin=
g:
>>
>> 1. Would it be recommended to use the --link option with the pg_upgrade
>> command, from disk space point of view?
>>
>
> Yes.
>
>
>> Are there any potential downsides to consider?
>>
>
> Very much: it's a one-way journey.  No rolling back if something
> goes wrong!
>
>
>> 2. Do you have any suggestions or best practices for performing an
>> efficient upgrade in a replication setup (streaming replication) for bot=
h
>> the primary and standby servers?
>>
>
> Streaming replication is not an upgrade method.  Logical replication is
> absolutely a valid method of upgrading PG on one server to PG on a
> different server.
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>

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

<div dir=3D"auto"><div>Thanks Ron for your suggestion.<div dir=3D"auto">So =
for pg upgrade in streaming replication setup, rsync will be a better optio=
n for standby upgrade if we are using --link option or recreating the stand=
by, once upgrade completes on primary? Any suggestions on this please.</div=
><div dir=3D"auto"><br></div><div dir=3D"auto">Best Regards,</div><div dir=
=3D"auto">Raman</div><br><br><div class=3D"gmail_quote"><div dir=3D"ltr" cl=
ass=3D"gmail_attr">On Mon, Nov 18, 2024, 22:41 Ron Johnson &lt;<a href=3D"m=
ailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com</a>&gt; wrote:<br></=
div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-lef=
t:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Mon=
, Nov 18, 2024 at 11:08=E2=80=AFAM Motog Plus &lt;<a href=3D"mailto:mplus75=
35@gmail.com" target=3D"_blank" rel=3D"noreferrer">mplus7535@gmail.com</a>&=
gt; wrote:<br></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"><div dir=3D"auto"><div dir=3D"auto">Dear Team,</div><=
div dir=3D"auto"><br></div><div dir=3D"auto">We are in the process of upgra=
ding our PostgreSQL database from version 12 to version 15. I would greatly=
 appreciate your advice on the following:</div><div dir=3D"auto"><br></div>=
<div dir=3D"auto">1. Would it be recommended to use the --link option with =
the pg_upgrade command, from disk space point of view? </div></div></blockq=
uote><div><br></div><div>Yes.</div><div>=C2=A0</div><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,=
204,204);padding-left:1ex"><div dir=3D"auto"><div dir=3D"auto">Are there an=
y potential downsides to consider?</div></div></blockquote><div><br></div><=
div>Very much: it&#39;s a one-way journey.=C2=A0 No rolling back if somethi=
ng goes=C2=A0wrong!</div><div>=C2=A0</div><blockquote class=3D"gmail_quote"=
 style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);p=
adding-left:1ex"><div dir=3D"auto"><div dir=3D"auto">2. Do you have any sug=
gestions or best practices for performing an efficient upgrade in a replica=
tion setup (streaming replication) for both the primary and standby servers=
?</div></div></blockquote><div><br></div><div>Streaming replication is not =
an upgrade method.=C2=A0 Logical replication is absolutely a valid method o=
f upgrading PG on one server to PG on a different server.</div><div>=C2=A0<=
/div></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D=
"ltr" class=3D"gmail_signature"><div dir=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>
</blockquote></div></div></div>

--000000000000e4442d0627332020--