Heroku Postgres Version Support
Last updated November 14, 2023
Table of Contents
The PostgreSQL project releases new major versions on a yearly basis. Heroku Postgres supports each major version shortly after its release.
While the PostgreSQL project supports a major version for five years after its initial release, Heroku supports a major version for three years on our platform. Heroku deprecates these versions to ensure no databases run on an unsupported major version of PostgreSQL. Heroku currently offers Postgres version 15 as the default. Currently supported versions include:
|9.6||Deprecated||November 11, 2021|
|10||Deprecated||November 10, 2022|
|11||Deprecated||November 9, 2023|
|12||Deprecating||May 30, 2024|
|15||Available (Default)||Q3 2026|
Users are required to upgrade roughly once every three years. We recommend upgrading your PostgreSQL version when a new one is available to gain the benefits of the latest version, such as security or performance enhancements.
We announce deprecations in the Changelog. Databases on deprecated versions are subject to forced upgrade attempts. End-of-life occurs six months after the deprecation date, and we start restricting database access and deleting databases for non-compliance.
To create a database on an older, supported PostgreSQL version use the –version flag with the
Deprecation and Migration of Deprecated Databases
When we release a new major version, we deprecate the third major version released before it. For example, Heroku Postgres 13 deprecates when Heroku Postgres 16 releases.
We updated our version policy starting with Heroku Postgres 13. Heroku Postgres 12 follows a different deprecation timeline.
- On the deprecation date, Heroku notifies customers via email about the deprecation process for their affected databases.
- Three months after the deprecation date, Heroku prevents provisioning new databases on the deprecated version. Creating forks and followers of existing databases is allowed.
- Five months after the deprecation date, Heroku schedules forced upgrades for databases that still run a deprecated version.
Heroku highly recommends that you perform the version upgrade before support ends so that you can test compatibility, plan for unforeseen issues, and migrate your database on your own schedule.
The end-of-life date of each version occurs six months after its deprecation date. We start restricting database access and deleting databases for non-compliance after this date.