Self-hosting is great, but every now and then you update something (Akkoma) and all of a sudden realize that you also need to pg_upgrade the original Pleroma database from Postgres 11 to 15.

@alpha I’ve been migrating my server to jails (containers) and ZFS volumes to make these kinds of migrations easier. If I need to upgrade Postgres it’s easy to create a new volume and jail and run pg_upgrade without battling packaging constraints

@alpha gulp

@drbrain Fortunately, it wasn’t too bad - I don’t know if it’s Postgres or Debian or what, but the versions were all separated within the appropriate directories, whew.

But same, I’m trying pretty hard to keep all new services in containers - Pleroma at the time didn’t have an image that I trusted and I am too unfamiliar w/the tech stack to want to roll my own there.

@drbrain Though also I got bit since it never occurred to me to actually update the database. A thing I was vaguely aware of in theory, but have not done dba things in a very long time and totally forgot this was a thing.

@tahnok Luckily it wasn’t too bad!