DocsICP FilingConsole
官方文档
首页

Manage extensions

更新时间：
复制 MD 格式
产品详情
我的收藏

This topic describes how to manage extensions for PolarDB using the PolarDB for PostgreSQL console. Supported operations include filtering, installing, uninstalling, upgrading, and checking for updates.

Prerequisites

The cluster must have at least one privileged account and one database.

Notes

  • If an extension requires preloading via the shared_preload_libraries parameter and is not already listed in the shared_preload_libraries parameter value, installing it automatically restarts the cluster.

    Note

    You can view the shared_preload_libraries parameter configuration in Parameter Settings to confirm whether the extension you plan to install depends on preloading via shared_preload_libraries and whether it is already included in the shared_preload_libraries parameter value.

  • Do not install the Ganos and PostGIS extensions in the same schema.

  • To install the ganos_tiger_geocoder or postgis_tiger_geocoder extensions, your cluster version must be PostgreSQL 14 (minor engine version 14.9.14.0 or later).

  • Uninstalling an extension may cause data loss or service disruption. Proceed with caution.

Procedure

  1. Log on to the PolarDB console and select the region of your cluster from the top navigation bar.

  2. Click the ID of your destination cluster to go to its Overview page.

  3. In the navigation pane on the left, choose Configuration and Management > Plugin Management.

  4. On the Extension Management page, you can filter, install, uninstall, upgrade, and check for updates for extensions.

Filter extensions

  1. On the Extension Management page, use the drop-down list in the upper-right corner to switch to your target database.

  2. In the upper-right corner, select one or more extension types from the Select an extension type drop-down list.

    Select your target database (such as testdb) from the database drop-down list in the upper-right corner to filter extensions available for that database.

Note

You can also enter an extension name directly in the search box in the upper-left corner to find a specific extension.

Install extensions

Install a single extension

Install a single extension using one of the following methods.

  • Install from the Extension Overview page.

    1. On the Extension Overview page, review popular extensions and their scenarios.

    2. Click Install next to your target extension.

    3. In the Install Extension dialog box, select the target Database Name and Database Account.

    4. Click OK to install the extension into the target database.

  • Install from the Extension Management page.

    1. On the Extension Management page, click the Uninstalled Extensions tab.

    2. Click Install in the Operation column for your target extension.

    3. In the Install Extension dialog box, select the target Database Account.

    4. Click OK to install the extension into the target database.

Install multiple extensions at once

You can also install multiple extensions in a batch.

  1. On the Extension Management page, click the Uninstalled Extensions tab.

  2. Select the extensions you want to install and click Batch Install.

  3. In the Install Extension dialog box, select the target Database Account.

  4. Click OK to install the extensions into the target database.

Uninstall extensions

Uninstall a single extension

  1. On the Extension Management page, click the Installed Extensions tab.

  2. Click Uninstall in the Actions column for your target extension.

  3. In the Uninstall Extension dialog box, click OK.

Uninstall multiple extensions at once

  1. On the Extension Management page, click the Installed Extensions tab.

  2. Select the extensions you want to uninstall and click Batch Uninstall.

  3. In the Uninstall Extension dialog box, click OK.

Important

Uninstalling an extension may cause data loss or service disruption. Proceed with caution.

Upgrade extensions

  1. On the Extension Management page, click the Installed Extensions tab.

  2. Click Update in the Operation column for your target extension to upgrade it to the latest version.

Note

If the Upgrade button in the Actions column is grayed out, the extension is already at the latest version.

Check for updates

  1. On the Extension Management page, click the Installed Extensions tab.

  2. Click Check for Updates to display a list of extensions that require upgrades.

Previous：Supported extensionsNext：Heterogeneous data access