rs5th

I’m running the following SQL, although I’m not actually sure it’s as necessary since 0.18.3. It doesn’t delete any post history or anything.

DELETE FROM activity WHERE published < NOW() - INTERVAL '1 day';

Hugo calls these sorts of things “frontends” and has a list here: https://gohugo.io/tools/frontends/

I haven’t had great luck with any of them personally.

I believe the activity table in Postgres is retained for 6 months (although I’m purging mine daily) and the pict-rs cache is 168 hours (1 week).

I’m running a Kubernetes cluster on the Dell hardware, then another single node k8s cluster on the Lenovo, mostly to run Adguard home / DNS in case the big cluster goes down for whatever reason.

Hardware:

• Two Dell r610s, each with 12 cores and 96 GB of RAM, running ESXi 6.7
• Lenovo M900, 4 core, 16 GB RAM, Ubuntu and k3s
• Synology 1515 with 12 TB usable
• Synology 1517 with 32 TB usable
• Juniper SRX 220H (Firewall)
• Juniper EX 2200 48 port switch
• UnFi in-wall WiFi APs

I run the following services, all in Kubernetes, with FluxCD doing GitOps from a repo in GitHub (for now, might move to Gitea later):

• Authentik
• Bookstack
• Calibre
• Flame (Homepage)
• Frigate NVR
• Home Assistant
• Memos
• Monica
• Plex
• Prowlarr
• Radarr
• Rocket Chat
• Sonarr
• Tandoor
• Tautulli
• Unifi
• UptimeKuma
• VS Code
• Zigbee2MQTT