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

From Abhijith Balan
Subject Re: Data format mismatch between minor versions
Date
Msg-id bbe40d5e-a453-aa77-88ec-135fbdbeb446@disroot.org
Whole thread Raw
In response to Re: Data format mismatch between minor versions  (Magnus Hagander <magnus@hagander.net>)
List pgsql-bugs

Thanks a lot Magnus. I think this must be the case. I have configured pacman to ignore updates for postgresql so that I can keep my working system.

On 14/11/20 8:36 pm, Magnus Hagander wrote:


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: Magnus Hagander
Date:
Subject: Re: PG 9.6.20 -- query misbehaves in replica
Next
From: Peter Geoghegan
Date:
Subject: Re: Unnecessary FOR UPDATE lock instead of possible FOR NO KEY UPDATE lock in an UPSERT statement