Conversation

Notices

1. Embed this notice
   Lunarised (lunarised@fsebugoutzone.org)'s status on Thursday, 04-Jul-2024 19:10:21 JST Lunarised

   • pistolero
   Hey, Pleroma nerds.
   
   I finished a db prune and my db is still 68GB for what i thought was a small instance. I did the vacuum afterwards
   
   
   Am i fucked?
   
   cc @p
   • Embed this notice
      (mint@ryona.agency)'s status on Thursday, 04-Jul-2024 19:10:17 JST 

     in reply to

     • pistolero
     @Lunarised @p It's normal, my DB is around 60 gigs as well and that's after deleting most of the unneccesary objects.
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Thursday, 04-Jul-2024 19:22:43 JST pistolero

     in reply to

     • 
     @mint @Lunarised
     please_wait_patiently.png
      likes this.
   • Embed this notice
     The MILF Messiah (lunarised@whinge.town)'s status on Thursday, 04-Jul-2024 19:37:17 JST The MILF Messiah

     in reply to

     • 
     • pistolero
     @mint @Lunarised @p I got it down to 40GB, which gives me more breathing room I guess. Might reindex it all sometime
      likes this.
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Thursday, 04-Jul-2024 19:37:28 JST pistolero

     in reply to
     @Lunarised
     
     > I finished a db prune and my db is still 68GB for what i thought was a small instance. I did the vacuum afterwards
     
     Well, worst-case you can dump and restore. I don't know what is being pruned, since I have never used the DB-pruning tool. You could try manually removing the activities/objects that are older than a certain date (and that are not Follow/Accept/Block), or just delete all of the Like/Announce/EmojiReact/Update/Delete activities.
     
     You wanna check the table sizes for all of the tables.
     
     Other than that, what's wrong with the DB being 68GB? That's how big they are.
     The MILF Messiah likes this.
   • Embed this notice
     The MILF Messiah (lunarised@whinge.town)'s status on Thursday, 04-Jul-2024 19:37:59 JST The MILF Messiah

     in reply to

     • pistolero
     @p @Lunarised just trying to keep the storage under control. Only have 120GB in the frantech box
   • Embed this notice
     on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ (lain@lain.com)'s status on Thursday, 04-Jul-2024 19:55:59 JST on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ

     in reply to

     • pistolero
     @Lunarised @p i think we really need to manage the db size expectations better
     Haelwenn /элвэн/ :triskell:, The MILF Messiah and Pleroma-tan like this.
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Thursday, 04-Jul-2024 19:58:39 JST pistolero

     in reply to

     • The MILF Messiah
     @lunarised @Lunarised Until we moved to our own box, I used to just make regular backups and I'd dump/restore when it got too big, because that took us down for less time than a full vacuum. People allegedly have a good time with pg_repack, but I have used it once and it fucks up if it is interrupted (like if you are running low on disk space and you attempt to run it to free up disk space and then it runs out of disk space), and even fucks up the *dump*.
     The MILF Messiah and ✙ dcc :pedomustdie: :phear_slackware: like this.
   • Embed this notice
     The MILF Messiah (lunarised@whinge.town)'s status on Thursday, 04-Jul-2024 19:59:07 JST The MILF Messiah

     in reply to

     • pistolero
     @p @Lunarised im gonna need to learn how to dump and restore sometime then!
   • Embed this notice
     The MILF Messiah (lunarised@whinge.town)'s status on Thursday, 04-Jul-2024 20:07:54 JST The MILF Messiah

     in reply to

     • on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ
     • pistolero
     @lain @Lunarised @p I'm just mentally slow and am not entirely sure what a reasonable size is
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Thursday, 04-Jul-2024 20:09:00 JST pistolero

     in reply to

     • The MILF Messiah
     @lunarised @Lunarised `pg_dump>file.sql` and `psql<file.sql`. You can put your favorite bytestream compressor in the pipeline if you like. (This is recommended.)
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     The MILF Messiah (lunarised@whinge.town)'s status on Thursday, 04-Jul-2024 20:10:00 JST The MILF Messiah

     in reply to

     • pistolero
     @p @Lunarised stop speaking witch. Now I gotta learn bytestteam compression....
     
     I should have stuck with surveying
   • Embed this notice
     on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ (lain@lain.com)'s status on Thursday, 04-Jul-2024 20:10:04 JST on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ

     in reply to

     • The MILF Messiah
     • pistolero
     @lunarised @Lunarised @p it's a reasonable size and database size does not impact perfomance greatly unless you haven't changed your postgres settings: https://docs.pleroma.social/backend/configuration/postgresql/
     The MILF Messiah and Pleroma-tan like this.
   • Embed this notice
     The MILF Messiah (lunarised@whinge.town)'s status on Thursday, 04-Jul-2024 20:10:52 JST The MILF Messiah

     in reply to

     • on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ
     • pistolero
     @lain @Lunarised @p was only worried since drive was nearly full, and I'm too poor to upgrade
     on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ likes this.
   • Embed this notice
     RedTechEngineer (redtechengineer@fedi.lowpassfilter.link)'s status on Thursday, 04-Jul-2024 20:39:08 JST RedTechEngineer

     in reply to

     • The MILF Messiah
     • pistolero
     @p @Lunarised @lunarised the @p stands for plumber
      and The MILF Messiah like this.
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Thursday, 04-Jul-2024 20:39:09 JST pistolero

     in reply to

     • The MILF Messiah
     @lunarised @Lunarised I'm just talking about pipes. `pg_dump | gzip > file.sql.gz` or `bzip2` or `pbzip2` or `pigz` or `lz4` or whatever. The data going down a pipe is a bytestream, I meant something that is friendly to put in a pipeline.
     The MILF Messiah likes this.
     The MILF Messiah repeated this.
   • Embed this notice
     The MILF Messiah (lunarised@whinge.town)'s status on Thursday, 04-Jul-2024 20:39:25 JST The MILF Messiah

     in reply to

     • RedTechEngineer
     • pistolero
     @RedTechEngineer @Lunarised @p possibly the best fedi post I've ever seen
   • Embed this notice
     :blank: (i@declin.eu)'s status on Thursday, 04-Jul-2024 20:39:36 JST :blank:

     in reply to

     • on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ
     • The MILF Messiah
     • pistolero
     @p @Lunarised @lain @lunarised rebuilding indexes, which are half or a third the size of the table itself, also takes down the instance any time the autovaccum comes on unless you run on a modern ssd raid, and even then, postgresql struggles to keep stuff real time
     The MILF Messiah likes this.
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Thursday, 04-Jul-2024 20:39:37 JST pistolero

     in reply to

     • on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ
     • The MILF Messiah
     @lain @lunarised @Lunarised
     
     > database size does not impact perfomance greatly
     
     Some of the indexes get massive, and they stop fitting in RAM. Indexes living on a large number of non-consecutive inodes can slow things down a lot.
     
     He's worried about running out of disk, though, and "instance does not come on" is the worst performance. :craysmile:
     on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ and The MILF Messiah like this.
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Thursday, 04-Jul-2024 20:58:20 JST pistolero

     in reply to

     • The MILF Messiah
     • :blank:
     @i @Lunarised @lunarised
     
     > as it avoids the https://blog.freespeechextremist.com/blog/activities-visibility-index-slowness.html issue when restoring,
     
     Ah, I should update that; putting the connection into replica mode actually speeds it *way* the hell up.
     
     > https://gitlab.com/-/snippets/2228488
     
     Did Gleason seriously try to use nano on a DB dump? "Editing dumps / I have no idea." The JavaScript guy doesn't think to use awk or sed, huge shock. Someone should tell him (or, since he mercifully has gone away to Nostr, someone should maybe upload some better instructions).
     
     > with --rsyncable
     
     I didn't know about this flag, but it appears to be a Debian extension. pbzip2 does fine.
     
     The bigger issue with this person's approach is that you will have to copy every block every time anyway; pg_dump gives you the dump in disk-order, and in a database where there are large tables with any amount of churn (Pleroma, this database), you will get a different order every time you dump, so rsync will not be able to just move the blocks that have changed.
     
     (Postgres does row-versioning and deletes rows in place by marking them as deleted. To keep the data consistent during transactions, if there is an update, rows are COW'd. New rows get put into empty slots where they fit, overwriting previous deletions.)
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     :blank: (i@declin.eu)'s status on Thursday, 04-Jul-2024 20:58:22 JST :blank:

     in reply to

     • The MILF Messiah
     • pistolero
     @p @Lunarised @lunarised a better guide is, https://gitlab.com/-/snippets/2228488 as it avoids the https://blog.freespeechextremist.com/blog/activities-visibility-index-slowness.html issue when restoring, and http://www.aktau.be/2014/10/23/pg-dump-and-pigz-easy-rsyncable-backups-with-postgresql/ with --rsyncable makes backing it up to another server easier
     
     mine compresses from 95GB to 11GB
     ✙ dcc :pedomustdie: :phear_slackware: repeated this.
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 21:20:27 JST Lina Inver?e

     in reply to

     • The MILF Messiah
     • :blank:
     • Pawlicker
     • pistolero
     @PurpCat @i @Lunarised @p @lunarised we officially outlasted the soyboy
   • Embed this notice
     Pawlicker (purpcat@clubcyberia.co)'s status on Thursday, 04-Jul-2024 21:20:28 JST Pawlicker

     in reply to

     • The MILF Messiah
     • :blank:
     • pistolero
     @p @i @Lunarised @lunarised fun fact Gleason hasn't been updating copebox otp builds and he's pushing people towards his nostr (deader than bsky) fetishism this month now
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 21:20:47 JST Lina Inver?e

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     • pistolero
     @PurpCat @Lunarised @i @lunarised @p hey doesnt this mean copebox instances will wither away too
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 21:23:32 JST Lina Inver?e

     in reply to

     • The MILF Messiah
     • :blank:
     • Pawlicker
     • pistolero
     @PurpCat @i @Lunarised @p @lunarised lol, anyway yea i think he'll either return eventually or he'll actually stay there and copebox will die and with it will the copebox instances
     WHICH IS GOOD THERE ISN'T A SINGLE GOOD COPEBOX INSTANCE HOW THE FUCK IS THE SOFTWARE TIED TO COMPLETELY CRINGE INSTANCES UNLIKE PLEMORA
   • Embed this notice
     Pawlicker (purpcat@clubcyberia.co)'s status on Thursday, 04-Jul-2024 21:23:33 JST Pawlicker

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • pistolero
     @lina @i @Lunarised @p @lunarised the only person I know trying to mess with his nostr stack is a Gleason disciple with no original thoughts of his own and oh btw it also is broken as fuck and has fewer people
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 21:25:23 JST Lina Inver?e

     in reply to

     • The MILF Messiah
     • :blank:
     • Pawlicker
     • pistolero
     @PurpCat @i @Lunarised @p @lunarised its only a matter of time
   • Embed this notice
     Pawlicker (purpcat@clubcyberia.co)'s status on Thursday, 04-Jul-2024 21:25:24 JST Pawlicker

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • pistolero
     @lina @i @Lunarised @p @lunarised imagine how funny it'd be if graf came out as a chaser or furry 🤣
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 21:26:00 JST Lina Inver?e

     in reply to

     • The MILF Messiah
     • :blank:
     • Pawlicker
     • Cocoa Hoto in real life
     • pistolero
     @Cocoa @PurpCat @i @Lunarised @p @lunarised oh wait, you run copebox? thank God there's one good copebox instance then
   • Embed this notice
     Cocoa Hoto in real life (cocoa@nekosat.work)'s status on Thursday, 04-Jul-2024 21:26:01 JST Cocoa Hoto in real life

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     • pistolero
     @lina @PurpCat @i @Lunarised @p @lunarised yeah I need to figure out how to migrate to stock Pleroma one of these days
   • Embed this notice
     Sick Sun (sun@shitposter.world)'s status on Thursday, 04-Jul-2024 21:29:46 JST Sick Sun

     in reply to

     • The MILF Messiah
     • :blank:
     • Phantasm
     • pistolero
     @p @i @phnt @Lunarised @lunarised he took a grant do develop some software so he's nose on grindstone mode.
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Thursday, 04-Jul-2024 21:29:47 JST pistolero

     in reply to

     • The MILF Messiah
     • :blank:
     • Phantasm
     @phnt @Lunarised @i @lunarised
     
     > because you can't use --disable-triggers as a normal user.
     
     Yeah, he mentions that you should run it as a superuser.
     
     > So that's why I haven't seen any of his posts in weeks.
     
     Fedi got a little comfier.
   • Embed this notice
     Phantasm (phnt@fluffytail.org)'s status on Thursday, 04-Jul-2024 21:29:49 JST Phantasm

     in reply to

     • The MILF Messiah
     • :blank:
     • pistolero
     @p @i @Lunarised @lunarised
     
     >Gleason
     Gleason's guide will also fail when restoring the backup, because you can't use --disable-triggers as a normal user. It needs to have the superuser option set or it needs to be restored as the postgres user instead of the pleroma user.
     
     >Gone away to Nostr
     So that's why I haven't seen any of his posts in weeks.
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 21:32:46 JST Lina Inver?e

     in reply to

     • The MILF Messiah
     • :blank:
     • Pawlicker
     • pistolero
     @p @PurpCat @i @Lunarised @lunarised just leave it to someone who enjoys rolling around in shit to find it, i can't be assed personally
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Thursday, 04-Jul-2024 21:32:47 JST pistolero

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     @PurpCat @lina @Lunarised @i @lunarised The chats got leaked; if that was the case, it'd be in there somewhere.
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 21:33:38 JST Lina Inver?e

     in reply to

     • The MILF Messiah
     • :blank:
     • Phantasm
     • Pawlicker
     • Cocoa Hoto in real life
     • pistolero
     @phnt @PurpCat @i @Lunarised @p @Cocoa @lunarised i fear the soyboy having a hateboner for plemora in fact did not
   • Embed this notice
     Phantasm (phnt@fluffytail.org)'s status on Thursday, 04-Jul-2024 21:33:39 JST Phantasm

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     • Cocoa Hoto in real life
     • pistolero
     @Cocoa @PurpCat @i @lina @Lunarised @p @lunarised Pray that the migrations he wrote are written properly and are reversible.
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 21:38:18 JST Lina Inver?e

     in reply to

     • The MILF Messiah
     • :blank:
     • Pawlicker
     • pistolero
     @p @PurpCat @i @Lunarised @lunarised true, he has enough eyes on him, but he's already considered a terminally alcoholic FTM troon with how many hissy fits he throws
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Thursday, 04-Jul-2024 21:38:19 JST pistolero

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     @lina @Lunarised @PurpCat @i @lunarised Yeah, I mean the people that enjoy that have had a year with them. If there was anything that bad, it would have come out.
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 21:43:03 JST Lina Inver?e

     in reply to

     • The MILF Messiah
     • :blank:
     • Pawlicker
     • pistolero
     @PurpCat @i @Lunarised @p @lunarised there's two moments
     firstly: it's not new, i heard it for a year or so now
     secondly: i don't really care because i don't mention them frequently
   • Embed this notice
     Pawlicker (purpcat@clubcyberia.co)'s status on Thursday, 04-Jul-2024 21:43:04 JST Pawlicker

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • pistolero
     @lina @i @Lunarised @p @lunarised pooner is the new insult for them btw
   • Embed this notice
     NonPlayableClown (nonplayableclown@postnstuffds.lol)'s status on Thursday, 04-Jul-2024 21:47:21 JST NonPlayableClown

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     • pistolero
     I mean he did get raped by a 300 lb woman and a uber driver.
     
     What more do you want from the man 🤣
     
     Oh one thing that the logs were revealed is that he's "jokingly" a bug chaser. :SeethingDanielS:
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 21:47:21 JST Lina Inver?e

     in reply to

     • The MILF Messiah
     • NonPlayableClown
     • :blank:
     • Pawlicker
     • pistolero
     @NonPlayableClown @PurpCat @i @Lunarised @p @lunarised the unicode emoji makes me doubt your claims, i get my e-celeb gossip only from trusted types, not disguised e-celeb worshippers
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 21:50:05 JST Lina Inver?e

     in reply to

     • The MILF Messiah
     • NonPlayableClown
     • :blank:
     • Pawlicker
     • pistolero
     @NonPlayableClown @PurpCat @i @Lunarised @p @lunarised that fat guy chudbuds couldnt stfu about and this crackhead purpcat posts about occasionally for starters, i'm sure there's more im unaware of
   • Embed this notice
     NonPlayableClown (nonplayableclown@postnstuffds.lol)'s status on Thursday, 04-Jul-2024 21:50:06 JST NonPlayableClown

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     • pistolero
     >disguised e-celeb worshippers
     
     What e-celeb do you think I worship 🤔
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 21:52:47 JST Lina Inver?e

     in reply to

     • The MILF Messiah
     • NonPlayableClown
     • :blank:
     • Pawlicker
     • pistolero
     @p @PurpCat @i @Lunarised @NonPlayableClown @lunarised sure thing tommy garcia
      likes this.
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Thursday, 04-Jul-2024 21:52:48 JST pistolero

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • NonPlayableClown
     • :blank:
     • Pawlicker
     @NonPlayableClown @lina @PurpCat
     
     :pinkwojak: graf
     👩 graf
     :pinkwojak: graf
     👩 graf
     
     Hey, @Lunarised @lunarised @i, I'm going to bail out of this thread so if there's more database stuff to discuss and I might be able to help, please tag me in a different thread.
     The MILF Messiah likes this.
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 21:53:46 JST Lina Inver?e

     in reply to

     • The MILF Messiah
     • NonPlayableClown
     • :blank:
     • Pawlicker
     • pistolero
     @NonPlayableClown @PurpCat @i @Lunarised @p @lunarised there's only a few fat guys that drama obsessed flesh automatons worship nonstop, and as far as im aware, those types dont watch cartoons
   • Embed this notice
     NonPlayableClown (nonplayableclown@postnstuffds.lol)'s status on Thursday, 04-Jul-2024 21:53:47 JST NonPlayableClown

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     • pistolero
     >that fat guy
     
     Man that narrows it down.
     
     I'm going to assume it's Petah.
     Which tbf I did one point of my life.
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 21:55:25 JST Lina Inver?e

     in reply to

     • The MILF Messiah
     • NonPlayableClown
     • :blank:
     • tsoifan1997
     • Pawlicker
     • pistolero
     @sysrq @PurpCat @i @Lunarised @p @NonPlayableClown @lunarised when i saw the thumbnail again after being on fedi for some time, i immediately recognized 's avatar in tommy garcia
   • Embed this notice
     tsoifan1997 (sysrq@lab.nyanide.com)'s status on Thursday, 04-Jul-2024 21:55:26 JST tsoifan1997

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • NonPlayableClown
     • :blank:
     • Pawlicker
     • pistolero
     @lina @PurpCat @i @Lunarised @p @NonPlayableClown @lunarised
     Obscure reference.
   • Embed this notice
     Pawlicker (purpcat@clubcyberia.co)'s status on Thursday, 04-Jul-2024 21:57:26 JST Pawlicker

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • NonPlayableClown
     • :blank:
     • pistolero
     @lina @i @Lunarised @p @NonPlayableClown @lunarised so glad I outgrew the edrama shit ngl
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 21:57:26 JST Lina Inver?e

     in reply to

     • The MILF Messiah
     • NonPlayableClown
     • :blank:
     • Pawlicker
     • pistolero
     @PurpCat @i @Lunarised @p @NonPlayableClown @lunarised yea, that shit's just gay
   • Embed this notice
     Pleroma-tan (kirby@lab.nyanide.com)'s status on Thursday, 04-Jul-2024 22:14:43 JST Pleroma-tan

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     • Cocoa Hoto in real life
     • pistolero
     @p @PurpCat @i @lina @Lunarised @Cocoa @lunarised where
   • Embed this notice
     pistolero (p@fsebugoutzone.org)'s status on Thursday, 04-Jul-2024 22:14:44 JST pistolero

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     • Cocoa Hoto in real life
     @lina @Cocoa @Lunarised @PurpCat @i @lunarised And btrf.ly has announced that they're going to be moving to stock Pleroma.
   • Embed this notice
      (mint@ryona.agency)'s status on Thursday, 04-Jul-2024 23:14:12 JST 

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     • Cocoa Hoto in real life
     • pistolero

     @i @PurpCat @lina @Lunarised @p @Cocoa @lunarised There's quite a few divergences, but less than in ackoma and nothing critical like password hash changes. Some new fields in users table might be troublesome, though.

     $ diff -uar <(ls -1 rebased/priv/repo/migrations) <(ls -1 pleroma/priv/repo/migrations) --- /proc/self/fd/11 2024-07-04 17:10:27.018383357 +0300 +++ /proc/self/fd/12 2024-07-04 17:10:27.019383356 +0300 @@ -274,7 +274,6 @@ 20210401143153_user_notification_settings_fix.exs 20210416051708_remove_mastofe_settings_from_users.exs 20210420204354_delete_hashtags_objects_cascade.exs -20210612185407_add_email_list_field_to_users.exs 20210717000000_add_poll_to_notifications_enum.exs 20210818023112_add_user_id_to_apps.exs 20211121000000_create_user_notes.exs @@ -287,10 +286,8 @@ 20220125104429_add_birthday_month_day_index_to_users.exs 20220203224011_create_rules.exs 20220220135625_upload_filter_exiftool_to_exiftool_strip_location.exs -20220225164000_add_activity_assigned_account_index.exs 20220302013920_add_language_to_users.exs 20220308012601_create_announcements.exs -20220314220000_add_location_to_users.exs 20220319000000_add_status_to_notifications_enum.exs 20220506175506_add_index_hotspots.exs 20220509180452_change_thread_visibility_to_be_local_only_aware.exs @@ -298,21 +295,23 @@ 20220602052233_change_report_notes_content_to_text.exs 20220605185734_add_update_to_notifications_enum.exs 20220616163503_add_expires_at_to_user_relationships.exs -20220624104914_create_webhooks.exs 20220711182322_add_associated_object_id_function.exs 20220711192750_switch_to_associated_object_id_index.exs 20220807125023_data_migration_delete_context_objects.exs -20220819171321_add_pleroma_participation_accepted_to_notifications_enum.exs 20220821004840_change_thread_visibility_to_use_new_object_id_index.exs 20220905011454_generate_unset_user_keys.exs -20220927220033_add_last_move_at_to_users.exs -20221029171353_add_internal_to_webhooks.exs 20221103014611_create_oban_peers.exs 20221103014728_swap_primary_oban_indexes.exs 20221111164213_deprecate_quack.exs -20221207235104_add_events_index.exs 20221216052127_add_state_to_backups.exs 20230306112859_instances_add_metadata.exs 20230422154018_drop_unused_indexes.exs 20230504173400_remove_user_ap_enabled.exs 20231107200724_consolidate_email_queues.exs +20240207035927_create_rich_media_card.exs +20240223165000_create_bookmark_folders.exs +20240406000000_add_hint_to_rules.exs +20240527144418_oban_queues_refactor.exs +20240530011739_add_missing_foreign_keys.exs +20240608003957_upgrade_oban_jobs_to_v12.exs +20240619141319_deprecate_config_db_logger.exs
   • Embed this notice
     :blank: (i@declin.eu)'s status on Thursday, 04-Jul-2024 23:14:14 JST :blank:

     in reply to

     • 
     • Lina Inver?e
     • The MILF Messiah
     • Pawlicker
     • Cocoa Hoto in real life
     • pistolero
     @PurpCat @lina @Lunarised @p @Cocoa @mint @lunarised for rebased, i don't think there's even been breaking changes to the DB schema, worth trying to just run pleroma off the same DB with no rollbacks
   • Embed this notice
     Pawlicker (purpcat@clubcyberia.co)'s status on Thursday, 04-Jul-2024 23:14:15 JST Pawlicker

     in reply to

     • 
     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Cocoa Hoto in real life
     • pistolero
     @Cocoa @i @lina @Lunarised @p @lunarised cc @mint
   • Embed this notice
      (mint@ryona.agency)'s status on Thursday, 04-Jul-2024 23:25:21 JST 

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     • Cocoa Hoto in real life
     • pistolero
     @Cocoa @PurpCat @i @lina @Lunarised @p @lunarised I've sent him a patch here on fedi for the report rejecting MRF to reject reports sent to third-party users (Gargron spam update, https://github.com/mastodon/mastodon/issues/27219), he accepted it but later I figured out I fucked it up and it was rejecting *all* remote report. I've made a bugfix and sent it to him twice, he acknowledged it first time but never bothered to commit it. Couldn't make a proper MR because shitlab's cloudflare check on login page dehumanizes me.
   • Embed this notice
     Cocoa Hoto in real life (cocoa@nekosat.work)'s status on Thursday, 04-Jul-2024 23:25:22 JST Cocoa Hoto in real life

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     • pistolero
     @lina @PurpCat @i @Lunarised @p @lunarised back when I first started the instance copebox was the more frequently updated fork so that's what I went with
     
     unfortunately I failed to learn my lesson the first time with Cocoa Hoto Rocks and Foundkey and now I have no updates again :why2:
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Thursday, 04-Jul-2024 23:58:16 JST Lina Inver?e

     in reply to

     • The MILF Messiah
     • :blank:
     • Pawlicker
     • Cocoa Hoto in real life
     • pistolero
     • cow
     @cow @PurpCat @i @Lunarised @p @Cocoa @lunarised cow reference has arrive
   • Embed this notice
     cow@m.moooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo.ooo's status on Thursday, 04-Jul-2024 23:58:18 JST cow

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     • Cocoa Hoto in real life
     • pistolero

     @Cocoa @lunarised @PurpCat @lina @Lunarised @i @p install mitra

   • Embed this notice
     Cocoa Hoto in real life (cocoa@nekosat.work)'s status on Friday, 05-Jul-2024 00:23:48 JST Cocoa Hoto in real life

     in reply to

     • 
     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     • pistolero
     @mint @PurpCat @i @lina @Lunarised @p @lunarised I imagine reverting all Soapbox migrations and running the stock Pleroma migrations would fix that? I rarely mess with the database so I wouldn't know exactly how to do that, but I'm sure it's possible
   • Embed this notice
      (mint@ryona.agency)'s status on Friday, 05-Jul-2024 00:23:48 JST 

     in reply to

     • Lina Inver?e
     • The MILF Messiah
     • :blank:
     • Pawlicker
     • Cocoa Hoto in real life
     • pistolero
     @Cocoa @PurpCat @i @lina @Lunarised @p @lunarised It should, yes. I don't remember what exact commad one needs to run to revert a single migration, though.