How to handle a user asking for 2FA reset? (Email sent by their correct @gmail address and is DKIM-signed by gmail.) #MastoAdmin
big SQL query
I just wrote an SQL query to find which accounts use the most storage space:
select * from (
select accounts.username, accounts.domain, sum(media_attachments.file_file_size) as media_size
from media_attachments
inner join accounts on (media_attachments.account_id=accounts.id)
group by accounts.id order by media_size desc
) as t
where t.media_size is not null
limit 10;
to run it: "su postgres", then "psql mastodon_production", then type it in the shell
I recently upgraded my Mastodon instance to Debian Buster, so I now have both pgsql 9.6 and 11 installed. (Currently, Mastodon still uses 9.6.)
Which one should I use (and why)?
#mastoadmin
To all instance admins: you should suspend the instance pleroma.rareome.ga, it advertises itself as leaking private messages.
(CW n-word on that link and the image) https://pleroma.rareome.ga/notice/55113
Python/Rust/Debian/IRC enthusiast. Trekkie.
GPG key: 0E082B40E4376B1E.