pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedData format mismatch between minor versions
4+ messages / 3 participants
[nested] [flat]
* Data format mismatch between minor versions
@ 2020-11-14 01:37 Abhijith Balan <abhijithb21@disroot.org>
2020-11-14 13:50 ` Re: Data format mismatch between minor versions Sergei Kornilov <sk@zsrv.org>
2020-11-14 15:06 ` Re: Data format mismatch between minor versions Magnus Hagander <magnus@hagander.net>
0 siblings, 2 replies; 4+ messages in thread
From: Abhijith Balan @ 2020-11-14 01:37 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Data format mismatch between minor versions
2020-11-14 01:37 Data format mismatch between minor versions Abhijith Balan <abhijithb21@disroot.org>
@ 2020-11-14 13:50 ` Sergei Kornilov <sk@zsrv.org>
1 sibling, 0 replies; 4+ messages in thread
From: Sergei Kornilov @ 2020-11-14 13:50 UTC (permalink / raw)
To: Abhijith Balan <abhijithb21@disroot.org>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Data format mismatch between minor versions
2020-11-14 01:37 Data format mismatch between minor versions Abhijith Balan <abhijithb21@disroot.org>
@ 2020-11-14 15:06 ` Magnus Hagander <magnus@hagander.net>
2020-11-15 02:46 ` Re: Data format mismatch between minor versions Abhijith Balan <abhijithb21@disroot.org>
1 sibling, 1 reply; 4+ messages in thread
From: Magnus Hagander @ 2020-11-14 15:06 UTC (permalink / raw)
To: Abhijith Balan <abhijithb21@disroot.org>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
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/;
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/;
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Data format mismatch between minor versions
2020-11-14 01:37 Data format mismatch between minor versions Abhijith Balan <abhijithb21@disroot.org>
2020-11-14 15:06 ` Re: Data format mismatch between minor versions Magnus Hagander <magnus@hagander.net>
@ 2020-11-15 02:46 ` Abhijith Balan <abhijithb21@disroot.org>
0 siblings, 0 replies; 4+ messages in thread
From: Abhijith Balan @ 2020-11-15 02:46 UTC (permalink / raw)
To: Magnus Hagander <magnus@hagander.net>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
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 <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/;
> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/;
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2020-11-15 02:46 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-11-14 01:37 Data format mismatch between minor versions Abhijith Balan <abhijithb21@disroot.org>
2020-11-14 13:50 ` Sergei Kornilov <sk@zsrv.org>
2020-11-14 15:06 ` Magnus Hagander <magnus@hagander.net>
2020-11-15 02:46 ` Abhijith Balan <abhijithb21@disroot.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox