Oof, need to find some way to claw back some Mastodon database space.

[liam@mastodon.gruezi.net]

Oof, need to find some way to claw back some Mastodon database space.

Anyone aware of a script that deletes old posts from remote users with 0 local followers or similar?

#MastoAdmin

[cadusilva@bolha.one]

@liam hey, it's in portuguese but you can use a translator to understand the comments:

https://jardim.social.br/administradores/script-limpeza/

You can also search for `pg_repack` and `vacuumdb`.

[spielleitung@mastodon.pnpde.social]

@liam here's what I use: https://codeberg.org/pnpde.social/scripts/src/branch/main/mastodon-maintenance.sh

It's really just some tootctl calls. Iow: Mastodon brings a tool for the task

[liam@mastodon.gruezi.net]

@cadusilva Thank you!

I had a bunch of the tootctl commands in a script that runs periodically already, but not the statuses remove one and didn't think to check the docs

[waffles@masto.yttrx.com]

@liam

# Prune remote accounts that never interacted with local users
tootctl accounts prune