Data format mismatch between minor versions

Started by Abhijith Balanover 5 years ago4 messagesbugs
Jump to latest
#1Abhijith Balan
abhijithb21@disroot.org

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

In reply to: Abhijith Balan (#1)
Re: Data format mismatch between minor versions

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

#3Magnus Hagander
magnus@hagander.net
In reply to: Abhijith Balan (#1)
Re: Data format mismatch between minor versions

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/ <http://www.hagander.net/&gt;
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/&gt;

#4Abhijith Balan
abhijithb21@disroot.org
In reply to: Magnus Hagander (#3)
Re: Data format mismatch between minor versions

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.

Show quoted text

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

On Sat, Nov 14, 2020 at 2:21 PM Abhijith Balan
<abhijithb21@disroot.org <mailto: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/ <http://www.hagander.net/&gt;
 Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/&gt;