cross-posted from: https://lemm.ee/post/15339951
My Lemmy instance has reached 100% storage so I can no longer use it. Is there a safe way I can clear cache or make some more space available without upgrading the disk space? I set up the instance with the ansible script many months ago and migrating to object storage seems to be a decent amount of work I don’t have to commit to currently.
I tried searching on the admin wiki (https://wiki.lemmyadmin.site) but I couldn’t find anything
I can’t switch to Object Storage just yet because I’m worried that since I have 0 space left there will be issues when trying to migrate so I need to make some space available and then make the switch to Object Storage
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.
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.
