PostgreSQL 12 now in Beta on Heroku Postgres

Change effective on 03 December 2019

Earlier last month, PostgreSQL 12.0 was released. Today, we are excited to announce PostgreSQL 12 is available in beta on Heroku, bringing a number of notable feature and performance improvements to our managed PostgreSQL database service.

The beta provides customers who want to try out the new release an easy way to do so, while customers who are happy with the current version can continue to stay on version 11 until we make version 12 generally available. New databases will continue to default to version 11 until we release version 12 to GA.

The PostgreSQL project’s release notes for version 12 can be found here: https://www.postgresql.org/docs/12/release-12.html.

To provision a new database with PostgreSQL 12, you can pass the --version 12 flag, like so:

heroku addons:create heroku-postgresql --version 12

Caveats

The following extensions are not available in the PostgreSQL 12 beta:

  • PostGIS

All other Heroku Postgres extensions are supported while PostgreSQL 12 is in beta on Heroku.