Follow
oh no this migration is not going to be painless
```
FATAL: database files are incompatible with server
mastodon-db
DETAIL: The data directory was initialized by PostgreSQL version 12, which is not compatible with this version 13.4.
```
@th
Yeah, postgres upgrades need a dump/restore. That always bites me as well. You may have a pg_upgrade script.
@th In case you're using docker: https://dpaste.org/v2yUp is what I built for postgres migrations. Start that docker-compose configuration, pointing at your database, then run the docker exec command to run the migration. "Worked for me"
@th good luck!!!
@billiegrace if all goes well things should be migrated! you'll need new creds to login again via SSO.
@th Good to go, thx!
@th do you have both 12 and 13 installed? if so, it’s easy to do. i did it from 13 to 15 the other day.
the steps, in summary: https://www.paulox.net/2022/04/28/upgrading-postgresql-from-version-13-to-14-on-ubuntu-22-04-jammy-jellyfish/
there are lots of blog posts (blogspam?) listing the same steps.