I don't have good advice for right now, but as for the future: always have a 5-10GB file on your server that you can delete in an emergency.
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: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.
-
No spam posting.
-
Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.
-
Don't duplicate the full text of your blog or github here. Just post the link for folks to click.
-
Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).
-
No trolling.
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!
Look at root reserved blocks on ext4, this is already the default
good idea
What's your filesystem? What is your storage setup currently? Can you get to a shell on the running OS?
You might want to boot to a live linux usb/disk/ISO mount your filesystem/drive that is full and delete your cached files from that.
Here's how to clear tables on a regular basis https://lemmy.world/post/207421?scrollToComments=true
Here's how to clear your cache in your postgres DB https://stackoverflow.com/questions/68816441/clearing-cache-in-postgresql
I would strongly suggest standing up your self hosted instance in a docker container if you haven't already
https://blog.colic.io/2023/07/07/self-hosting-lemmy-a-step-by-step-guide-with-docker-compose/
Also now might be a good idea to look at grabbing a cheap external drive and backing up to that as a worst case.
https://join-lemmy.org/docs/administration/backup_and_restore.html
im running ubuntu on a vps. I can get a shell running. I don't see where in that thread it mentions how to clear the tables?
I set up Lemmy using the Ansible setup so it is in docker
I have backups automatically running every week.
I believe you want to look at the activity table. I don't have an instance, but the linked thread mentions it.