pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Data 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>
  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 13:50  Sergei Kornilov <sk@zsrv.org>
  parent: Abhijith Balan <abhijithb21@disroot.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 15:06  Magnus Hagander <magnus@hagander.net>
  parent: 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-15 02:46  Abhijith Balan <abhijithb21@disroot.org>
  parent: Magnus Hagander <magnus@hagander.net>
  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