Thanks for the suggestion. However, for now I'd like to avoid building my entire app "the Heroku way", and keep the PostgreSQL server hosted on the same server or at least the same network as the rest of the app. But you are right in that perhaps a fully managed PostgreSQL server is the way to go for reliability.