How to free up space pictrs or postgres

willya, 6 months ago

Lemmy Post Purger

txmyx, 6 months ago

1. Upgrade your storage. 160GB is nothing and 1TB SSDs are cheap
2. You could delete pictures, but then the posts are broken
3. You could archive old pictures. The pictures will have a longer load-time. Also I don’t think archiving pictures is a feature of lemmy, so you would have to implement it yourself

Edit: I think postgres is so big, because of backups. You could delete those, but that’s risky

skariko, 6 months ago

Thank you for your answer!

Since I currently use Hetzner the only way to get more space is to upgrade the server (at a not inconsiderable cost).

The alternative might be to purchase SSD block storage volumes which are definitely lower priced (5€ per month for 100GB) however it would be interesting to know if there is a guide for Lemmy for this or if others have had positive experience doing this.

nachtigall, 6 months ago

You could get a storage box which is just 3.81€ for 1TB and mount it via NFS or SSHFS. That’s how we are doing it at Feddit.de

skariko, 6 months ago

Thanks i think this is a great idea.

Since this problem I think is quite common (at least from reading a few threads and comments around) it might be interesting to create a guide especially regarding the part of having lemmy use this/mounted volume instead of the default one.

I in the meantime will try to look around for some information on how this can be done, any advice is definitely welcome.

Thanks!

nachtigall, 6 months ago

I’d just ping @wintermute here as he might tell you more about it.