Selfhosted
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:
-
Be civil.
-
No spam.
-
Posts are to be related to self-hosting.
-
Don't duplicate the full text of your blog or readme if you're providing a link.
-
Submission headline should match the article title.
-
No trolling.
-
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.
-
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:
- selfh.st Newsletter and index of selfhosted software and apps
- awesome-selfhosted software
- awesome-sysadmin resources
- Self-Hosted Podcast from Jupiter Broadcasting
Any issues on the community? Report it using the report flag.
Questions? DM the mods!
view the rest of the comments
Firstly move pict-rs to object storage. My instance's pict-rs uses 150GB alone. I pay less than $2/mo to put it on Cloudflare R2. Backblaze B2 might be even cheaper. Instructions: https://crates.io/crates/pict-rs#filesystem-to-object-storage-migration
If that doesn't help enough and you're comfortable with SQL, you can purge the unnecessary entries in
received-activities.Command:
delete from received_activity where published & NOW() - INTERVAL '3 days';(Lemmy has problems with ampersands so you'll have to edit it)Then do a
vacuum full received_activity;to reclaim the space.This deleted 98 million entries for me and reduced my database size from 49GB to 20GB a week ago when I started running out of space. No other effect as far as I can tell. Thanks @illecors@lemmy.cafe
Thank you, that SQL command looks like exactly what I'm after! I'm going to give that a shot. I appreciate the help!
what is stored in
received_activity? anything important? I mean obviously it's something the instance has received from other instances but is this then stored somewhere else (like comments then stored elsewhere for eg)in v0.19.0 Lemmy will automatically delete entries over 7 days old
https://github.com/LemmyNet/lemmy/issues/4113
https://github.com/LemmyNet/lemmy/commit/cb01427dcff14b3d88e30220695fc97978786a9a
currently it waits 3 months before deleting
Time to update then!
it's in alpha currently, but you could still run it
I think you might have to use the
:devtag to get this update, a bit risky to stay on that tag though, maybe wait for the next docker image of an alpha releaseTa, good to know
Well now you can use
:0.19.0-rc.5:)epic :)
oh btw 3rd party apps aren't working with 0.19.0 yet, because of changes to the authentication API
Good to know. I'll check it out.
As far as I've been told it's basically just a log of all received activities. Nothing references it.
Nothing seems to have gone wrong in the past week on thelemmy.club since I removed it. I do have backups though.
Nice, thank you.