DocsICP FilingConsole
官方文档
首页

Install, update, and uninstall extensions

更新时间：
复制 MD 格式
我的收藏

This topic explains how to install, uninstall, and update extensions for AnalyticDB for PostgreSQL in the console.

Prerequisites

The AnalyticDB for PostgreSQL instance must be in the Running state.

Go to the Extensions page

  1. Log on to the AnalyticDB for PostgreSQL console.

  2. In the upper-left corner of the console, select a region and click the target instance's ID.

  3. In the left navigation bar, click Extensions to go to the Extensions page.

Install extensions

You can install extensions for AnalyticDB for PostgreSQL in the console (recommended) or by submitting a ticket.

Note

If you cannot find the desired extension on the Extensions page, submit a ticket to contact technical support.

Single installation

  1. On the Extensions page, find the target extension and click Install in the Actions column.

  2. In the Install Extension dialog box, select the target database or all databases and click Install.

  3. After 1 to 5 minutes, when the status of the AnalyticDB for PostgreSQL instance changes from Installing to Running, verify that the extension status is Installed.

Batch installation

  1. On the Extensions page, click Batch Install in the upper-left corner.

  2. In the Batch Install Extensions dialog box, select the target extensions and the target database, and click Install.

  3. In 1 to 5 minutes, after the status of the AnalyticDB for PostgreSQL instance changes from Installing Extension to Running, verify that the extension status is Installed.

Note

After you install the following extensions, the AnalyticDB for PostgreSQL instance automatically restarts for the extensions to take effect. During the restart, the AnalyticDB for PostgreSQL instance cannot be read from or written to.

  • pg_hint_plan

  • pg_stat_statements

Uninstall extensions

You can uninstall extensions for AnalyticDB for PostgreSQL in the console (recommended) or by submitting a ticket.

Note

If you cannot find the desired extension on the Extensions page, submit a ticket to contact technical support.

To uninstall an extension from the Extensions page in the console, follow these steps:

  1. On the Extensions page, find the extension you want to uninstall and click Uninstall in the Actions column.

  2. In the Uninstall Extension dialog box, select the database from which to uninstall the extension, and click Uninstall.

  3. On the Extensions page, verify that the extension is uninstalled.

Important

Uninstalling an extension can lead to data loss and service unavailability. Proceed with caution.

Update extensions

You can upgrade an extension if a later version is available for the kernel version of your AnalyticDB for PostgreSQL instance. On the Extensions page, click Upgrade in the Actions column of the target extension to upgrade it to the latest version.

Note

  • If the Actions column for an extension does not show an Upgrade option, the extension is already the latest version.

  • We recommend that you update extensions during off-peak hours.

FAQ

ERROR: permission denied to create extension "uuid-ossp"

Cause: You cannot install the uuid-ossp extension by using the CREATE EXTENSION statement.

Solution: Install the extension on the Extensions page in the console.

Previous：Supported extensionsNext：Roaring Bitmap