oh no this migration is not going to be painless
FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 12, which is not compatible with this version 13.4.

@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:

there are lots of blog posts (blogspam?) listing the same steps.

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: 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"

@billiegrace if all goes well things should be migrated! you'll need new creds to login again via SSO.

Sign in to participate in the conversation
(void *) social site