Postgres Pro
Downloads
Home   >   mailing lists

Re: Data format mismatch between minor versions - Mailing list pgsql-bugs

From Magnus Hagander
Subject Re: Data format mismatch between minor versions
Date
Msg-id CABUevEw=oo_HqYrSGjtZ+erEHUXk952aga+XKufSPbK2mJgyOw@mail.gmail.com
Whole thread Raw
In response to Data format mismatch between minor versions  (Abhijith Balan <abhijithb21@disroot.org>)
Responses Re: Data format mismatch between minor versions
List pgsql-bugs
Tree view


On Sat, Nov 14, 2020 at 2:21 PM Abhijith Balan <abhijithb21@disroot.org> wrote:
Hi!

I upgraded Postgresql from version 12.4.3 to version 12.5-3 and
Postgresql reported that "old version of the database format was found".
AFAIK this message usually appears after upgrade between major versions
when there are drastic changes in internal storage format. I now have a
working system back after downgrading the package to 12.4.3.


I am using Arco Linux, an Arch Linux based distribution. Upgrade was
done using package manager pacman. Downgrade was done using cache files
of pacman.

There have been reports of packaging issues on arch around the updates recently, see for example https://bugs.archlinux.org/task/68601. 

Perhaps the same bug made its way downstream into your distribution?
 
--

pgsql-bugs by date:

Previous
From: Andy S
Date:
Subject: Re: BUG #16714: INSERT ON CONFLICT DO UPDATE fails to infer constraint if it's not at top-level partition
Next
From: Magnus Hagander
Date:
Subject: Re: PG 9.6.20 -- query misbehaves in replica