For anyone looking at this in 2025:
Fly.io is building a Managed Postgres product called Fly MPG, which should have a first version around Feb or Mar 2025: