Rediger

Del via

Update extensions

  • Artikkel

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

Before dropping extensions in Azure Database for PostgreSQL flexible server, you must allowlist them.

Steps to update extensions

To update an installed extension to the latest available version supported by Azure, use the following SQL command:

ALTER EXTENSION <extension> UPDATE;

This command simplifies the management of database extensions by allowing users to manually upgrade to the latest version approved by Azure, enhancing both compatibility and security.

Limitations

While updating extensions is straightforward, there are certain limitations:

  • Selection of a specific version: The command doesn't support updating to intermediate versions of an extension.

  • Downgrading: Doesn't support downgrading an extension to a previous version. If a downgrade is necessary, it might require support assistance and depends on the availability of the previous version.

Related content