MIME-Version: 1.0
References: <CAEcMXhmBGDWQnVwvhcg-2SPn4PM=PS+aZCouZiu=FEusevWskA@mail.gmail.com>
In-Reply-To: <CAEcMXhmBGDWQnVwvhcg-2SPn4PM=PS+aZCouZiu=FEusevWskA@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 13 Aug 2024 08:00:23 -0400
Message-ID: <CANzqJaCo+rXt-RD=4vPy8pZqp5Gm8TEKjf=Ksu_X5jfE+=c=PA@mail.gmail.com>
Subject: Re: PG Dump on 11 - Restore on 16 - is possible?
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000064b97b061f8f5b2e"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCo%2BrXt-RD%3D4vPy8pZqp5Gm8TEKjf%3DKsu_X5jfE%2B%3Dc%3DPA%40mail.gmail.com>
Precedence: bulk

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

On Tue, Aug 13, 2024 at 5:47=E2=80=AFAM Durumdara <durumdara@gmail.com> wro=
te:

> Hello!
>
> We have to upgrade our server. The PG upgrade is impossible because of to=
o
> much data.
> So we will create a new server with PG 16, and we have to migrate the
> databases one by one (from a PG 11 server).
>

I'd also recommend that you update the PG 11 server to 11.22 if possible.

It can hopefully be found here:
https://yum.postgresql.org/repopackages/#pgredhatoldrepos

--=20
Death to America, and butter sauce.
Iraq lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Aug 13, 2024 at 5:47=E2=80=AFAM D=
urumdara &lt;<a href=3D"mailto:durumdara@gmail.com">durumdara@gmail.com</a>=
&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_=
quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,=
204);padding-left:1ex"><div dir=3D"ltr">Hello!<div><br></div><div>We have t=
o upgrade our server. The PG upgrade is impossible because of too much=C2=
=A0data.</div><div>So we will create a new server with PG 16, and we have t=
o migrate the databases one by one (from a PG 11 server).</div></div></bloc=
kquote><div><br></div><div>I&#39;d also recommend that you update the PG 11=
 server to 11.22 if possible.</div><div><br></div><div>It can hopefully be =
found here: <a href=3D"https://yum.postgresql.org/repopackages/#pgredhatold=
repos">https://yum.postgresql.org/repopackages/#pgredhatoldrepos</a></div><=
div><br></div></div><span class=3D"gmail_signature_prefix">-- </span><br><d=
iv dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to America,=
 and butter sauce.<div>Iraq lobster!</div></div></div></div>

--00000000000064b97b061f8f5b2e--