Data format mismatch between minor versions

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Data format mismatch between minor versions

Abhijith Balan
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




Reply | Threaded
Open this post in threaded view
|

Re: Data format mismatch between minor versions

Sergei Kornilov
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


Reply | Threaded
Open this post in threaded view
|

Re: Data format mismatch between minor versions

Magnus Hagander-2
In reply to this post by Abhijith Balan


On Sat, Nov 14, 2020 at 2:21 PM Abhijith Balan <[hidden email]> 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?
 
--
Reply | Threaded
Open this post in threaded view
|

Re: Data format mismatch between minor versions

Abhijith Balan

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 <[hidden email]> 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?
 
--