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
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.