Home > mailing lists

PG Dump on 11 - Restore on 16 - is possible? - Mailing list pgsql-general

From	Durumdara
Subject	PG Dump on 11 - Restore on 16 - is possible?
Date	August 13, 2024 09:47:10
Msg-id	CAEcMXhmBGDWQnVwvhcg-2SPn4PM=PS+aZCouZiu=FEusevWskA@mail.gmail.com Whole thread Raw
Responses	Re: PG Dump on 11 - Restore on 16 - is possible? Re: PG Dump on 11 - Restore on 16 - is possible? Re: PG Dump on 11 - Restore on 16 - is possible? Re: PG Dump on 11 - Restore on 16 - is possible?
List	pgsql-general

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

From: Tom Lane
Date: 13 August 2024, 04:27:11
Subject: Re: Problem with a Query

From: Kashif Zeeshan
Date: 13 August 2024, 09:53:13
Subject: Re: PG Dump on 11 - Restore on 16 - is possible?