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
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
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)?
Python/Rust/Debian/IRC enthusiast. Trekkie.
GPG key: 0E082B40E4376B1E.
oc.todon.fr is an actively-moderated mostly French-speaking Mastodon instance. oc.todon.fr est une instance Mastodon principalement francophone et avec une modération active.