No particular love for Heroku, but you can pay for multi az failover if you want it.

https://devcenter.heroku.com/articles/heroku-postgres-ha

If you don’t pay you won’t get the feature. Given that multi az failover directly impacts their cost that seems pretty fair.