Postgres 15 now generally available on Heroku Postgres

Change effective on 09 March 2023

We previously released Postgres 15 beta on Heroku Postgres. Today, we’re excited to make PostgreSQL 15 generally available on Heroku.

All newly provisioned databases default to PostgreSQL 15.

Read the PostgreSQL project’s release notes for version 15 here.

Test Upgrade to PostgreSQL 15 on Heroku Postgres

You can use pg:upgrade and pg:copy to upgrade your database to PostgreSQL 15. 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 15. Installing the PostGIS extension on PG 15 installs PostGIS 3 by default. Databases that are upgraded via pg:upgrade also have their PostGIS version automatically upgraded to 3.3.