@Gargron Thanks for the work you've done and may the force be with you 💪 . It made me self-host my own instance and it's working pretty well :)
If this can help someone else doing the same thing, I made a quick tutorial and ansible role based on the docker images provided by Mastodon here: https://gitlab.comwork.io/oss/ansible-iac/mastodon

@Gargron I wonder if it wouldn’t be better if we try to replace PostgreSQL with a high available distributed and compatible implementation such as Yugabytes (cc @FranckPachot ), maybe we’ll be able to horizontally scale on the cloud :) https://www.yugabyte.com