• 1 Post
  • 27 Comments
Joined 1 year ago
cake
Cake day: June 25th, 2023

help-circle













  • I don’t know about lemmy.world but I assume they “purged” the user instead of banning them (or at least that’s what I did for my instance). Purging wipes all of their data from your instance and exists as a feature basically for this reason. That means that the user wouldn’t have a visible account to ban anymore because it literally removes them from the database.

    Only way to be sure that your server doesn’t have any of their content on it.



  • I ran this query:

    select distinct thumbnail_url as url from post where not local and thumbnail_url like 'https://campfyre.nickwebster.dev/pictrs%'
    

    (replace with your instance’s url)

    I then sent delete requests to /internal/purge on pictrs to delete all of those old thumbnails, which cleared out a lot of space. After deleting the thumbnails I ran an UPDATE query to set all of those old thumbnail URLs to null in the DB. I also patched the version of lemmy that I run to stop caching thumbnails in the future. Hope this helps!