Обсуждение: Data format mismatch between minor versions

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.


Regards,

Abhijith

Hello

Postgresql version 12.4.3 does not exist. There were releases of versions 12.3, 12.4, 12.5 and no something like
12.x.y.Are you sure you are using postgresql and not any fork?
 
Also postgresql will report "database files are incompatible with server" (with corresponding details about mismatched
values).I cannot find the text "old version of the database format was found".
 

regards, Sergei

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

 

--

 Magnus Hagander
 Me: https://www.hagander.net/
 Work: https://www.redpill-linpro.com/