When does Heroku Postgres failover?

A database failure or slow response doesn't immediately trigger a database failover in the Heroku PostgreSQL database service. The Heroku PostgreSQL support ensures that the application database really needs a failover (as it involves some cost to switch to a new database instance and shut down the previous one), besides setting up new configuration and making the application live again on the new database. Heroku support runs a suite of tests to confirm that a failover is the only option. The tests are run for a given period of time, usually two minutes, across different application dynos to see a consistency in the database response behavior. Only when it is detected that the database is not responsive for ...

Get Heroku Cloud Application Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.