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: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Date: Tue, 13 Aug 2024 14:53:13 +0500
Message-ID: <CAAPsdhdQP3LwyR-3iSddkEw5HdO6YOuzT--3DkBdJ3EPRKwuJw@mail.gmail.com>
Subject: Re: PG Dump on 11 - Restore on 16 - is possible?
To: Durumdara <durumdara@gmail.com>
Cc: Postgres General <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a7738d061f8d941b"
Archived-At: <https://www.postgresql.org/message-id/CAAPsdhdQP3LwyR-3iSddkEw5HdO6YOuzT--3DkBdJ3EPRKwuJw%40mail.gmail.com>
Precedence: bulk

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

Hi

On Tue, Aug 13, 2024 at 2:47=E2=80=AFPM 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).
>
> Is it possible?
>
> Does PG16 read PG11 dumps and restore them correctly on the PG16 server?
>
PG provides backward compatibility so you can restore PG11 backup to PG16.

>
> Or is it unsupported now?
>
> Thank you!
>
> Best regards
> dd
>

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

<div dir=3D"ltr"><div dir=3D"ltr">Hi</div><br><div class=3D"gmail_quote"><d=
iv dir=3D"ltr" class=3D"gmail_attr">On Tue, Aug 13, 2024 at 2:47=E2=80=AFPM=
 Durumdara &lt;<a href=3D"mailto:durumdara@gmail.com">durumdara@gmail.com</=
a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><d=
iv dir=3D"ltr">Hello!<div><br></div><div>We have to upgrade our server. The=
 PG upgrade is impossible because of too much=C2=A0data.</div><div>So we wi=
ll create a new server with PG 16, and we have to migrate the databases one=
 by one (from a PG 11 server).</div><div><br></div><div>Is it possible?</di=
v><div><br></div><div>Does PG16 read PG11 dumps and restore them correctly =
on the PG16 server?</div></div></blockquote><div>PG provides backward=C2=A0=
compatibility so you can restore PG11 backup to PG16.</div><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid r=
gb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div><br></div><div>Or i=
s it unsupported now?</div><div><br></div><div>Thank you!</div><div><br></d=
iv><div>Best regards</div><div>dd</div></div>
</blockquote></div></div>

--000000000000a7738d061f8d941b--