#pgrepack — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #pgrepack, aggregated by home.social.
-
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!
-
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!