PostgreSQL extension upgrades enabled for Essential tier

Change effective on 18 April 2023

Postgres extension upgrades are now available to all Essential tier Postgres add-on (Mini and Basic) plans. Previously users got the following error when attempting to upgrade an extension:

Extension updates are disabled, you may drop the extension and re-create it.

We disabled extension upgrades as part of our response to Incident 2450/CVE 2022-2625 and our continued commitment to keeping your data safe. Over the past few months, we’ve implemented alternative security measures and will be deploying this change to all of our Standard, Premium, Private, and Shield tier Postgres add-ons in the near future.

Try it for yourself on any of our Mini or Basic plans through the CLI in a heroku pg:psql session.

Create an extension and specify the version with the command:

CREATE EXTENSION extension_name VERSION '1.0';

Upgrade the extension with the command:

ALTER EXTENSION extension_name UPDATE TO '1.1';

Visit the Dev Center for more information on installing PostgreSQL extensions.