#mastoadmins

Calling on fediverse moderators: if you see a post that kind of, sort of borders on racism, but you're not really too sure: yep, you're definitely dealing with a racist. Learn about dog whistles. And microaggressions. Get a Black person on your moderation team. None of the redesigns and user experience tweaks will matter if we can't make this place welcoming to everyone. #fediverse #FediMeta #FediAdmins #MastoAdmins #racism #BlackFedi #BlackMastodon

Upgraded the Mastodon backend postgresql server from 14 to 18 with pgautoupgrade. Found out that I had some uniqueness violations (possibly due to collation changes) that needed some manual DB operations to merge accounts and remove duplicate entries before I could run tootctl maintenance fix-duplicates. Then used pg_repack to remove bloat and finally used REINDEX to fix the last bits.

Everything's fresh and smooth again!

#MastoAdmins #PgAutoUpgrade #PgRepack #postgresql #postgres

RE: https://stefanbohacek.online/@stefan/116563099730866203 Just a reminder that if you're an admin or a moderator, it should be your responsibility to step in when someone is harassing a member of your community and claiming to be enforcing rules that don't apply to them. #fediverse #FediAdmins #MastoAdmins #moderators

If I wanted to run a PostgreSQL query on my masto server which shows my personal home timeline as the result, does anyone have any pointers to guides or even such a query itself? Please boost for reach. #MastoAdmin #SelfHosting #MastoAdmins #PostgreSQL

#MastoAdmins: has anyone had a problem with all quoted posts saying "Post pending", but when I open the post on the original server, the quoted post displays fine? I'm on v4.6.0, but it's been doing it for several versions, but it used to work. Reloading the page on my server doesn't help either. Sometimes, if I favourite or boost the post on my server, the "post pending" quote then displays immediately. I've checked my Sidekiq queues and all sizes are "0". I did have a problem before when the "more replies" function was implemented, and I had to separate the pull queue into a new service (because the pull queue kept building up overnight) , but that is stable now. #MastoAdmin

#MastoAdmins I've just upgraded to 4.6.0, and now there's only one file where you have to change the character limit..... 🥳 Maybe the age of being able to change it via the web GUI is nearly upon us...... 🤞 #MastoAdmin

Is there a website that shows Mastodon versions in use by the number of accounts, not just servers? #mastodon #fediverse #MastoAdmins #FediAdmins