Postgres 17 is generally available on Heroku Postgres
Change effective on 28 May 2025
We previously released Postgres 17 beta on Heroku Postgres. Today, Postgres 17 is generally available on Heroku. New databases default to Postgres 17.
Read the Postgres project’s release notes for version 17 here.
Test the Upgrade to Postgres 17 on Heroku Postgres
With the release of Postgres 17, we’re deprecating Postgres 14 per our policy. We urge you to upgrade your databases to the latest version as soon as possible. To upgrade your database to Postgres 17, use the new version upgrade commands, pg:copy, or pg:upgrade, which is changing.
For Standard-tier and higher databases, test the upgrade with pg:upgrade:dryrun or with a forked database.
PostGIS Upgrades
Installing the PostGIS extension on PG 17 installs PostGIS 3 by default. Upgrading your database to PG 17 also upgrades the PostGIS version to 3.5.