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.