MIME-Version: 1.0
References: 
 <CAL5GnisA0RJ=Rd5e6yw4nsCB+DtAS1=iquBKTH76MknnTsHrPg@mail.gmail.com>
In-Reply-To: 
 <CAL5GnisA0RJ=Rd5e6yw4nsCB+DtAS1=iquBKTH76MknnTsHrPg@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 18 Nov 2024 12:11:14 -0500
Message-ID: 
 <CANzqJaA1VyGqPUQaeT9vfxNV1C3rQJSdMHa9xtzx+rJQhkY2gw@mail.gmail.com>
Subject: Re: Guidance Needed for PostgreSQL Upgrade from 12 to 15
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000aefc9206273301ae"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaA1VyGqPUQaeT9vfxNV1C3rQJSdMHa9xtzx%2BrJQhkY2gw%40mail.gmail.com>
Precedence: bulk

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

On Mon, Nov 18, 2024 at 11:08=E2=80=AFAM Motog Plus <mplus7535@gmail.com> w=
rote:

> Dear Team,
>
> We are in the process of upgrading our PostgreSQL database from version 1=
2
> to version 15. I would greatly appreciate your advice on the following:
>
> 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 both
> 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.

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

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

<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:mplus7535@gmail.com">mplus7535@gmail.com</=
a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmai=
l_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,20=
4,204);padding-left:1ex"><div dir=3D"auto"><div dir=3D"auto">Dear Team,</di=
v><div dir=3D"auto"><br></div><div dir=3D"auto">We are in the process of up=
grading our PostgreSQL database from version 12 to version 15. I would grea=
tly appreciate your advice on the following:</div><div dir=3D"auto"><br></d=
iv><div dir=3D"auto">1. Would it be recommended to use the --link option wi=
th the pg_upgrade command, from disk space point of view? </div></div></blo=
ckquote><div><br></div><div>Yes.</div><div>=C2=A0</div><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex"><div dir=3D"auto"><div dir=3D"auto">Are there=
 any potential downsides to consider?</div></div></blockquote><div><br></di=
v><div>Very much: it&#39;s a one-way journey.=C2=A0 No rolling back if some=
thing goes=C2=A0wrong!</div><div>=C2=A0</div><blockquote class=3D"gmail_quo=
te" 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">2. Do you have any =
suggestions or best practices for performing an efficient upgrade in a repl=
ication setup (streaming replication) for both the primary and standby serv=
ers?</div></div></blockquote><div><br></div><div>Streaming replication is n=
ot an upgrade method.=C2=A0 Logical replication is absolutely a valid metho=
d of 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 di=
r=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>

--000000000000aefc9206273301ae--