Postgres 16 is now generally available on Heroku Postgres
Change effective on 29 April 2024
We previously released Postgres 16 beta on Heroku Postgres. Today, PostgreSQL 16 is generally available on Heroku. New databases default to Postgres 16.
Read the PostgreSQL project’s release notes for version 16 here.
Test the Upgrade to PostgreSQL 16 on Heroku Postgres
You can also use pg:upgrade and pg:copy to upgrade your database to PostgreSQL 16. You can test on your existing data by forking your database and then following the pg:upgrade process.
PostGIS Upgrades
PostGIS 2.x is only supported on PostgreSQL 13 and earlier. Installing the PostGIS extension on PG 16 installs PostGIS 3 by default. Upgrading your database to PG 16 via pg:upgrade also upgrades the PostGIS version to 3.3.