Post #4236931

Upgraded the Mastodon backend postgresql server from 14 to 18 with pgautoupgrade. Found out that I had some uniqueness violations (possibly due to collation changes) that needed some manual DB operations to merge accounts and remove duplicate entries before I could run `tootctl maintenance fix-duplicates`. Then used pg_repack to remove bloat and finally used `REINDEX` to fix the last bits. Everything's fresh and smooth again! #MastoAdmins #PgAutoUpgrade #PgRepack #postgresql #postgres