this post was submitted on 07 Jun 2024
286 points (99.7% liked)
Announcements
23326 readers
1 users here now
Official announcements from the Lemmy project. Subscribe to this community or add it to your RSS reader in order to be notified about new releases and important updates.
You can also find major news on join-lemmy.org
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Great stuff peeps! Looks like my future is very busy with having to do a complex pictrs upgrade and then a postgres and finally lemmy. Oof! ๐
Thx! Let me know if the postgres upgrade helper script I provided has any issues.
My postgres is on bare metal, so I don't think the script is setup for that,is it?
The script will be useless to you, besides for referencing what to do.
Export, remove pg15, install pg16, import. I think you can streamline with both installed at once as they correctly version. You could also use the in place upgrade. Aptly named:
pg_upgradeclustersBut updating to 0.19.4, you do not need to go to pg16... but... you should, because of the benefits!
What benefits do you mean?
A faster db. Just the regular performance benefits, https://www.postgresql.org/about/news/postgresql-16-released-2715/
Also, Lemmy is built against v16 (now) so at some point it will eventually no longer JustWork
The script is pretty easy to read and follow along manually if you need to.