Update extensions in Azure Database for PostgreSQL flexible server

Before dropping extensions in an Azure Database for PostgreSQL flexible server, 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 you to manually upgrade to the latest version approved by Azure, enhancing both compatibility and security.

Limitations

While updating extensions is straightforward, certain limitations exist:

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

  • It constantly updates the latest available version.

• Downgrading: The command 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

• Extensions and modules
• Special considerations with extensions and modules
• List of extensions and modules by name
• List of extensions and modules by version of PostgreSQL