Maintenance Windows

Last Updated: 27 May 2015

Table of Contents

From time to time, Heroku must take your database offline to perform maintenance tasks. Typical tasks include upgrading the underlying infrastructure of the database (i.e. patching the operating system or required libraries) or upgrading Postgres itself. This maintenance is handled automatically by Heroku.

Checking if maintenance is required for your database

You can check if maintenance is required on a database by using pg:info.

$ heroku pg:info
Plan:           Standard 4
Status:         Available
Data Size:      26.1 MB
...
Maintenance:    required by 2014-02-01 00:00:00 +0000

Setting a Maintenance window

Some database plans support set-able maintenance windows. Users can specify the day-of-week and time (UTC) at which the maintenance will occur:

$ heroku pg:maintenance window="Sunday 14:30"

Setting a maintenance window allows you to minimize the impact on your application and users. We recommend selecting a time during which maintenance would have the least-impact on your business. By default, maintenance windows are 4 hours long starting at the time you specify.

Limitations

User settable maintenance windows and manual maintenance runs are only available on all standard, premium and enterprise plans.

Heroku will make best efforts to honor your maintenance window request; however it is not guaranteed. If there is an emergency where the security or integrity of your data is threatened, we may perform the maintenance outside of your regular window at our discretion.