• 0 Posts
  • 26 Comments
Joined 1 year ago
cake
Cake day: June 10th, 2023

help-circle





  • My understanding is that postgres doesn’t need to be upgraded. It’ll still work with version 15 or whatever you have. Postgres 15 has some sort of memory leak that they’re trying to get away from, so they made 16 the new default.

    Same with the “requirement” to upgrade pict-rs to the latest version. You can keep the old version if you don’t care about the new image proxy feature.

    Really it’s a not a problem of needing to upgrade this stuff, but a problem with the documentation which isn’t clear. That’s a big weak spot for the Lemmy project in my opinion. I only learned the above information from lurking a bit in the Matrix chat.




  • The upgrade went smoothly for me. Be smart with your backups with this one!

    Upgrading to postgres 16 was the hardest part. You need to pg_dump the lemmy database, upgrade to postgres 16 (which will complain in the logs that the current data isn’t compatible), delete the database folder (don’t delete the backup file from pg_dump!), then import the backup file into postgres 16.

    I had already upgraded pict-rs to version 0.5+ so that was easy.

    Then I compared the new lemmy.hjson with what I already had to get the new pict-rs setting for proxied images (turned off for now).

    Overall a lot more complex than previous upgrades.

    Be smart with your backups with this one!

    One more thing to consider if you’re using Debian 12 is it comes with postgres 15, so if you you’re using the bare metal to make backups, you’ll need to install postgres 16 using the instructions here.