Conversation

Notices

1. Alex Gleason (alex@gleasonator.com)'s status on Sunday, 25-Dec-2022 03:32:48 JST Alex Gleason

   • :pascal:

   If you upgraded to Pleroma 2.5 and it destroyed your database, you need to run pg_repack. I promise this will fix it, confirmed in multiple cases: https://gitlab.com/soapbox-pub/rebased/-/snippets/2463995

   Then you need to switch to Rebased as your backend: https://gitlab.com/-/snippets/2411739
   
   RT: https://shitposter.club/objects/e1d4fc28-06db-4640-b43d-6cc25f829792

   • 🌲Number 1 Pleroma Criminal on XBL 🇵🇱|🇺🇸 (phenomx6@fedi.pawlicker.com)'s status on Sunday, 25-Dec-2022 03:32:47 JST 🌲Number 1 Pleroma Criminal on XBL 🇵🇱|🇺🇸

     in reply to

     • :pascal:
     The instructions for the second snippet are a little out of date for OTP, you need to remove/rename the folders it tries to overwrite when moving the files into the directory.
   • 🌲Number 1 Pleroma Criminal on XBL 🇵🇱|🇺🇸 (phenomx6@fedi.pawlicker.com)'s status on Sunday, 25-Dec-2022 03:40:02 JST 🌲Number 1 Pleroma Criminal on XBL 🇵🇱|🇺🇸

     in reply to

     • :pascal:
     Done :)
   • Alex Gleason (alex@gleasonator.com)'s status on Sunday, 25-Dec-2022 03:40:03 JST Alex Gleason

     in reply to

     • 🌲Number 1 Pleroma Criminal on XBL 🇵🇱|🇺🇸
     • :pascal:

     @PhenomX6 @triodug Plz reply to the snippet with a comment. I’ll eventually move that snippet into proper docs and fix it then.

     🌲Number 1 Pleroma Criminal on XBL 🇵🇱|🇺🇸 repeated this.
   • Shari Vegas :windmill_of_friendship: :1488: (sharivegas@pleroma.nobodyhasthe.biz)'s status on Sunday, 12-Mar-2023 08:11:47 JST Shari Vegas :windmill_of_friendship: :1488:

     in reply to

     • 🌲Number 1 Pleroma Criminal on XBL 🇵🇱|🇺🇸
     • :pascal:
     @alex @PhenomX6 @triodug Move it into docs ASAP, Alex. I ran a pg_repack on my Akkoma install, and it completely eliminated the gross seq scans in my objects table.
     
     I do have a question about indexes, but I'm just not bothered enough to remember to ask it.
   • 🌲Number 1 Pleroma Criminal on XBL 🇵🇱|🇺🇸 (phenomx6@fedi.pawlicker.com)'s status on Sunday, 12-Mar-2023 08:12:24 JST 🌲Number 1 Pleroma Criminal on XBL 🇵🇱|🇺🇸

     in reply to

     • Shari Vegas :windmill_of_friendship: :1488:
     • :pascal:
     @ShariVegas @alex @triodug it's way better than purging imo