this post was submitted on 17 Jun 2023
47 points (100.0% liked)

Selfhosted

60758 readers
167 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

Detailed Rules Post

  1. Be civil.

  2. No spam.

  3. Posts are to be related to self-hosting.

  4. Don't duplicate the full text of your blog or readme if you're providing a link.

  5. Submission headline should match the article title.

  6. No trolling.

  7. Promotion posts require active participation, with an account that is at least 30 days old. F/LOSS without a paywall has exceptions, with requirements. See the rules link for details. Tags [CBH] or [AIP] are required, see the links in Rule 8 for details.

  8. AI-related discussions and AI-involved promotional posts have additional requirements for tagging, as noted in Rule 7 and the AI & Promotional Post Expanded Rules post, and find example disclosures here.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 3 years ago
MODERATORS
ruud@lemmy.world
Loki@lemmy.world
CannaVet@lemmy.world
devve@lemmy.world
ayyy@sh.itjust.works
curbstickle@anarchist.nexus
curbstickle_lw@lemmy.world
47
Lemmy self-hosters. What is your image cleanup process? (158436977.xyz)
submitted 3 years ago by idle@158436977.xyz to c/selfhosted@lemmy.world
26 comments fedilink hide all child comments
 

I'm self-hosting the docker containers and I noticed the pictrs directory is steadily growing because of the cached images. Does anyone know if it gets cleaned up automatically or are hosters running scripts to clean it up after a certain amount of time? The install guides make no mention of it from what I can find.

you are viewing a single comment's thread
view the rest of the comments
[–] a253040@midwest.social 7 points 3 years ago (4 children)

IIRC, I've read comments elsewhere that pictrs caches for 6 months, but I can't independently verify. I hope this gets a broader answer because I'm still on the fence about getting an instance set up for myself and some small communities.

[–] rs5th@lemmy.scottlabs.io 8 points 3 years ago (3 children)

I believe the activity table in Postgres is retained for 6 months (although I’m purging mine daily) and the pict-rs cache is 168 hours (1 week).

[–] a253040@midwest.social 9 points 3 years ago (1 children)

I knew I read something was kept for 6 months ;)

Glad to see that even here, the best way to get the right answer on the internet is to provide a wrong one.

[–] notacat@lemmy.fmhy.ml 1 points 3 years ago

Nothing has made me more hopeful of lemmy’s future than this.

[–] idle@158436977.xyz 6 points 3 years ago (1 children)

Only 1 week? That should be fine. Thanks!

[–] Jamie@jamie.moe 5 points 3 years ago

I was starting to sweat a little because my instance, that only I use, already has 600MB of pictures after less than 24 hours. The server has more than enough space, but I still wouldn't like it. A week is far more swallow-able.

[–] Quindius@lemmy.world 1 points 2 years ago (1 children)

How do you purge daily? Also, does that delete any post history or anything in a similar vein?

[–] rs5th@lemmy.scottlabs.io 1 points 2 years ago

I’m running the following SQL, although I’m not actually sure it’s as necessary since 0.18.3. It doesn’t delete any post history or anything.

DELETE FROM activity WHERE published < NOW() - INTERVAL '1 day';
[–] nii236@lemmy.jtmn.dev 5 points 3 years ago

Related note, pictrs is super cool. Its like an OSS imgur backend, but no one really talks much about it or its potential.

load more comments (2 replies)