MIME-Version: 1.0
From: Durumdara <durumdara@gmail.com>
Date: Tue, 13 Aug 2024 11:47:10 +0200
Message-ID: <CAEcMXhmBGDWQnVwvhcg-2SPn4PM=PS+aZCouZiu=FEusevWskA@mail.gmail.com>
Subject: PG Dump on 11 - Restore on 16 - is possible?
To: Postgres General <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000007060f061f8d7fc2"
Archived-At: <https://www.postgresql.org/message-id/CAEcMXhmBGDWQnVwvhcg-2SPn4PM%3DPS%2BaZCouZiu%3DFEusevWskA%40mail.gmail.com>
Precedence: bulk

--00000000000007060f061f8d7fc2
Content-Type: text/plain; charset="UTF-8"

Hello!

We have to upgrade our server. The PG upgrade is impossible because of too
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).

Is it possible?

Does PG16 read PG11 dumps and restore them correctly on the PG16 server?

Or is it unsupported now?

Thank you!

Best regards
dd

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

<div dir=3D"ltr">Hello!<div><br></div><div>We have to upgrade our server. T=
he 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 to migrate the databases o=
ne by one (from a PG 11 server).</div><div><br></div><div>Is it possible?</=
div><div><br></div><div>Does PG16 read PG11 dumps and restore them correctl=
y on the PG16 server?</div><div><br></div><div>Or is it unsupported now?</d=
iv><div><br></div><div>Thank you!</div><div><br></div><div>Best regards</di=
v><div>dd</div></div>

--00000000000007060f061f8d7fc2--