Thread

1. Base files compatibility between PG11 and PG15

   Abraham, Danny <danny_abraham@bmc.com> — 2023-08-17T09:32:47Z

   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?
   
   Thanks
   
   Danny
   
   
   
   

2. Sv: Base files compatibility between PG11 and PG15

   Andreas Joseph Krogh <andreas@visena.com> — 2023-08-17T10:10:11Z

   
   På torsdag 17. august 2023 kl. 11:32:47, skrev Abraham, Danny <
   danny_abraham@bmc.com <mailto: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/12.0/>
   
   https://www.postgresql.org/docs/release/13.0/ 
   <https://www.postgresql.org/docs/release/13.0/>
   
   https://www.postgresql.org/docs/release/14.0/ 
   <https://www.postgresql.org/docs/release/14.0/>
   
   https://www.postgresql.org/docs/release/15.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
   andreas@visena.com <mailto:andreas@visena.com>
   www.visena.com <https://www.visena.com>
    <https://www.visena.com>
   

3. Re: Base files compatibility between PG11 and PG15

   Adrian Klaver <adrian.klaver@aklaver.com> — 2023-08-17T14:36:20Z

   On 8/17/23 02:32, Abraham, Danny wrote:
   > 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.
   
   This needs more information:
   
   1) Describe the upgrade process
   
   2) Describe the data problems.
   
   > Has anyone met similar issues? Compatibility of data files?
   > 
   > Thanks
   > 
   > Danny
   > 
   > 
   
   -- 
   Adrian Klaver
   adrian.klaver@aklaver.com
   
   
   
   
   

4. Re: Base files compatibility between PG11 and PG15

   Bruce Momjian <bruce@momjian.us> — 2023-08-17T23:39:21Z

   On Thu, Aug 17, 2023 at 07:36:20AM -0700, Adrian Klaver wrote:
   > On 8/17/23 02:32, Abraham, Danny wrote:
   > > 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.
   > 
   > This needs more information:
   > 
   > 1) Describe the upgrade process
   > 
   > 2) Describe the data problems.
   
   Plus it is Aurora, which is not community Postgres.
   
   -- 
     Bruce Momjian  <bruce@momjian.us>        https://momjian.us
     EDB                                      https://enterprisedb.com
   
     Only you can decide what is important to you.