Arch Linux

4on6

Member

Registered: 2011-10-05

Posts: 172

[SOLVED ]Accidental Postgresql upgrade from 12 to 13

Hello,
after the fact I found out I should have protected my postgresql installation from unintended upgrade in the pacman config, but I didn't, so I had a major version upgrade from 12 to 13, and I'm left with an unaccesable database now (which was created with version 12).

I found two solution approaches on the net:

1. downgrade postgresql via pacman

2. install postgresql 12 via docker, export data from 12, import in 13

but the downgrade option did not seem so great (risk of incoherencies and later problems?), and I have no experience with docker.

Which is the better way? Is there any other solution?

Last edited by 4on6 (2021-02-01 18:23:41)

Scimmia

Fellow

Registered: 2012-09-01

Posts: 13,660

Re: [SOLVED ]Accidental Postgresql upgrade from 12 to 13

https://wiki.archlinux.org/index.php/Po … PostgreSQL provides multiple options.

4on6

Member

Registered: 2011-10-05

Posts: 172

Re: [SOLVED ]Accidental Postgresql upgrade from 12 to 13

https://wiki.archlinux.org/index.php/Po … PostgreSQL provides multiple options.

Thanks, I missed that page, especially this option seems promising:
"For those wishing to use pg_upgrade, a postgresql-old-upgrade package is available that will always run one major version behind the real PostgreSQL package"