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: https://www.postgresql.org/docs/14/release-14.html.
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.