My pictrs volume got quite huge and I wanna delete pics cached from other instances. The thing is I’m not sure which pics are from my instance and which aren’t, because they all have cryptic filenames. Anyone knows of a way to differentiate?

  • Maiznieks@lemmy.world
    link
    fedilink
    arrow-up
    5
    ·
    1 year ago

    Maybe you have to crossmatch db content to files (with a script) and remove anything that is not relevant? I don’t manage instance, so i might be completely off.

    • maor@lemmy.org.ilOP
      link
      fedilink
      arrow-up
      3
      ·
      1 year ago

      That’s beautiful, looks exactly like what I was looking for. Thank you, I’ll let you know when I try it how it went

      • maor@lemmy.org.ilOP
        link
        fedilink
        arrow-up
        1
        ·
        edit-2
        1 year ago

        It’s working but I suspect it doesn’t delete pics or smth. But it’s nice to have nontheless

  • Tiff@reddthat.com
    link
    fedilink
    English
    arrow-up
    4
    ·
    edit-2
    1 year ago

    I would recommend Backblaze B2 storage instead of removing post history.

    The problem with post removal is that it will affect all other instances’ as you don’t (by default) cache original images from other fediverse instances (iirc)

    So for example, my instance Reddthat will reference an image hosted on your instance, which will then 404. (But the thumbnail will be cached (I think))

    Backblaze is dirt cheap and the pictrs object migration is now multi threaded making it very easy to migrate now. I was hosting 15GB and it amounted to bills of cents! $5/TB or $0.005 per GB. If you add CloudFlare Infront you then get free egress! Or any CDN that is part of the “Bandwidth alliance”. I now have ~120GB of pictrs storage. After 2-3 months.

    Also, there was a recent chat on the lemmy admin matrix channel about setting some variable in pictrs so it does not cache any images. But I don’t remember what it was so maybe check the pictrs documentation.

    • skankhunt42
      link
      fedilink
      arrow-up
      2
      ·
      1 year ago

      I’m reading about this now. Thank you.

      Do you put cloudflare between the VPS and Backblaze or is their website just referring to “CDN and compute partners” between the VPS and the end users? … Or both?

      • Tiff@reddthat.com
        link
        fedilink
        English
        arrow-up
        3
        ·
        1 year ago

        To get it completely free it would need to be:

        • cloudflare > vps
        • cloudflare > backblaze

        Because Lemmy does not have a way to have all media served from a different url/subdomain (like a CDN). Your setup will be:

        • cloudflare > vps
          • vps > backblaze

        Basically just put cloudflare infront of your vps, and cache everything.

        That means if a user uploaded a 10MB file, it would go though your VPS, get uploaded to backblaze. When a user looks at the uploaded image url, on the first request it gets requested from blackblaze, via your vps, and then gets cached on Cloudflare.

        Then any extra requests from then on will be via Cloudflare. So you will technically be charged for some api requests and 1x 10MB of egress traffic.

        • skankhunt42
          link
          fedilink
          arrow-up
          2
          ·
          edit-2
          1 year ago

          Sounds like a normal setup then. Just have CF in front of the VPS. Thanks!

          I’m reading about Canadian hosting laws around user generated content and it doesn’t seem like we have the same protections the US or EU has. I’m still reading but my big concern is legal trouble because of end users. If I don’t selfhost for the community I’ll offer to help an instance I like.

          Thanks again!