PostgreSQL 14 now generally available for Heroku Postgres

Change effective on 23 March 2022

At the end of last year, PostgreSQL 14 was released. Today, we are excited to announce PostgreSQL 14 is available on Heroku, bringing a number of notable features and performance improvements to our managed PostgreSQL database service.

For Hobby plans, all newly provisioned databases will default to PostgreSQL 14.

For production plans, new databases will continue to default to version 13. We will announce any further default version changes via our Changelog.

The PostgreSQL project’s release notes for version 14 can be found here:

Running PostgreSQL 14 on Heroku Postgres

To provision a new database with PostgreSQL 14, you can pass the --version 14 flag, like so:

heroku addons:create heroku-postgresql --version 14

You can also use pg:upgrade and pg:copy to upgrade your database to PostgreSQL 14. You can test on your existing data by forking your database and then following the pg:upgrade process.

PostGIS upgrades

PostGIS 2.x is no longer supported on PostgreSQL 14. Installing the PostGIS extension on PG 14 will install PostGIS 3 by default. Databases that are upgraded via pg:upgrade will also have their PostGIS version automatically upgraded to 3.2.