val @val@oc.todon.fr

How to handle a user asking for 2FA reset? (Email sent by their correct @gmail address and is DKIM-signed by gmail.) #MastoAdmin

#MastoAdmin

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

#mastoadmin