14 days later, my postgres directory was 12GB. I was still on 18.1. Updated to 18.3 just now. Postgres directory was downscaled to 2.6GB !!! Thank you Lemmy dev’s and contributors !!

pictrs isn’t even taking up that much space, postgres takes up most !

# du -sch volumes/*
8.0K	volumes/lemmy-ui
3.4G	volumes/pictrs
8.2G	volumes/postgres
12G	total

I also noticed the logs were growing and taking up quite some gb’s. I’ve used truncate to make the syslog smaller and journalctl vacuum to keep that smaller

i’m trying to find documentation for this config but can’t find any. Do you have a link maybe ?

thanks for your detailed how-to ! Will try this, hopefully it holds 2 more weeks I’m leaving for holidays now :)

oh it’s visible because I’m admin/ mod ?

actually I did delete the server (after creating a snapshot of it) a week or so ago. But this morning I wanted to check lemmyfly.org, couldn’t load the page. Checking my Hetzner dashboard I noticed CPU was spiked at 200%?! It did drop again though, but apparently had last for 2-3 minutes. But prometheus was down, so no graphs apart from the hetzner ones. I doesn’t relate to network traffic spikes, so I don’t know what caused it. I’ve started the prometheus server again (that snapshot was really useful :) ) and will leave it on for a couple of months now.

current system consumption:

I might need to get an extra volume for storage, Lemmy is starting to eat up the root filesystem… Does anyone know how I re-configure Lemmy to look at a different volume for storage ?

For me it were the last 30 or something entries in local_user. They all didn’t have email_verified. I access the db through Postico. Also removed all other older accounts that didn’t verify their email address

Mine too I see now. You can only ban a user when they have posted something right ? There is no list for admins of all users registered ? Maybe I’ll do it direct in the database…

Good idea thanks :)

with what purpose ? posting stuff, or some other use ?

why all these upvotes? This post is on top of my posts since yesterday.

http_response metrics are also up, using https://github.com/martin-helmich/prometheus-nginxlog-exporter

would be nice to see the numbers go up :)

Let us know your findings when you did!

i’m now looking into logging more specific http request data. Maybe https://github.com/martin-helmich/prometheus-nginxlog-exporter?

I use namecheap’s email service privateemail since a couple of years. Google workspace was great, but don’t need the other features anymore and this is fifth of the price https://www.namecheap.com/hosting/email/

or the community you are posting to doesn’t allow Undetermined language, and that’s what you’ve selected. There is no error handling for that yet

Where can I find these stats?

look for communities you’re interested in here: https://browse.feddit.de/ and subscribe and enjoy the lemmyverse :)

How can people afford to host an instance? Aren’t there costs to hosting a server?

my instance (currently only 18 users) is on a basic server plan costing me ± $7,- a month. When that’s becoming much higher I’ll ask for donations to help me out (and I’ll be fully transparent on the current server costs and how much is donated)