Postgres Pro
Downloads
Home   >   mailing lists

Sv: Base files compatibility between PG11 and PG15 - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject Sv: Base files compatibility between PG11 and PG15
Date
Msg-id VisenaEmail.b48.50eaf865edbcab97.18a02f76c79@origo01.app.internal.visena.net
Whole thread Raw
In response to Base files compatibility between PG11 and PG15  ("Abraham, Danny" <danny_abraham@bmc.com>)
List pgsql-general
Tree view
På torsdag 17. august 2023 kl. 11:32:47, skrev Abraham, Danny <danny_abraham@bmc.com>:
Hi,

I have a database on Aurora@RDS.
It Used  V11.9, and then upgraded automatically by AWS to V15.2 AWS states that it relies on compatibility provided by the PG community.
We now experience problems with the data.
Has anyone met similar issues? Compatibility of data files?

The data-files are nowhere near compatible between major-versions, as stated clearly in all release notes:

https://www.postgresql.org/docs/release/12.0/

https://www.postgresql.org/docs/release/13.0/

https://www.postgresql.org/docs/release/14.0/

https://www.postgresql.org/docs/release/15.0/

 

They all state the same:

“A dump/restore using pg_dumpall or use of pg_upgrade or logical replication is required for those wishing to migrate data from any previous release.”

 

--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

pgsql-general by date:

Previous
From: "Abraham, Danny"
Date:
Subject: Base files compatibility between PG11 and PG15
Next
From: rob stone
Date:
Subject: Re: Cast INTEGER to BIT confusion