#mastoadmins

6 posts · Last used 15d

Back to Timeline
Jeroen Postma 🇪🇺 @jpostma@mastodon.clusterfucks.nl · Jul 30, 2026

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

3
0
1
Stefan Bohacek @stefan@stefanbohacek.online · Jul 18, 2026
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
Quoting
Stefan Bohacek @stefan@stefanbohacek.online

Applauding @admin@blorbo.social for taking a strong, well-argued stand on this.

Can we get more admins onboard?

Open quoted post
30
1
19
europlus :autisminf: @europlus@social.europlus.zone · Jul 19, 2026
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
0
2
1
Chewie @chewie@mammut.gogreenit.net · Jun 23, 2026
#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
0
1
0
Chewie @chewie@mammut.gogreenit.net · Jun 18, 2026
#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
0
1
0
Stefan Bohacek @stefan@stefanbohacek.online · Jun 17, 2026
Replying to @stefan@stefanbohacek.online
Is there a website that shows Mastodon versions in use by the number of accounts, not just servers? #mastodon #fediverse #MastoAdmins #FediAdmins
8
0
3

You've seen all posts