PostgreSQL 11 now in beta on Heroku Postgres

Change effective on 06 November 2018

Earlier this month, PostgreSQL 11.0 was released. Today, we are excited to announce PostgreSQL 11 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 10 until we make version 11 generally available. Also, new databases will continue to default to version 10 until we release version 11 to GA.

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

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

heroku addons:create heroku-postgresql --version 11

Caveats

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

  • PostGIS
  • plv8

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