445
submitted 1 year ago* (last edited 1 year ago) by Blaze@sopuli.xyz to c/fediverse@lemmy.ml
you are viewing a single comment's thread
view the rest of the comments
[-] delendum@lemdit.com 25 points 1 year ago

The DB migration at the end of this upgrade is significant, I was surprised how long it took when I upgraded my instance. Lots of room for things to go wrong considering the size of their DB.

[-] Blaze@sopuli.xyz 6 points 1 year ago

That makes sense, especially how large the instance is. Just curious, how long did the migration take for you? Half an hour?

[-] poVoq@slrpnk.net 16 points 1 year ago

10-15 minutes here on a 32gb database.

[-] delendum@lemdit.com 9 points 1 year ago

It took about the same for me.

[-] Blaze@sopuli.xyz 4 points 1 year ago

Interesting, thanks

[-] pimeys@lemmy.nauk.io 2 points 1 year ago* (last edited 1 year ago)

Took me the whole day. The new migrations require PostgreSQL version 15, and my Akkoma and Lemmy are using a shared database server of version 13. First shut down both services, then update Debian from 11 to 12, PostgreSQL from 13 to 15 and after all this, redeploy Lemmy to start the migrations. The new Lemmy queries use more RAM compared to the previous version, so the database was getting OOM and I needed to upgrade to a bigger instance.

Not fun, but everything works now and is stable.

[-] Blaze@sopuli.xyz 1 points 1 year ago

Interesting, thanks

this post was submitted on 29 Jul 2023
445 points (93.0% liked)

Fediverse

17776 readers
39 users here now

A community dedicated to fediverse news and discussion.

Fediverse is a portmanteau of "federation" and "universe".

Getting started on Fediverse;

founded 5 years ago
MODERATORS