Manage PostgreSQL extensions for your AnalyticDB for PostgreSQL instance directly from the console. This topic covers installing (single or batch), updating, and uninstalling extensions.
Prerequisites
Before you begin, make sure that:
-
Your AnalyticDB for PostgreSQL instance is in the Running state
Go to the Extensions page
-
Log on to the AnalyticDB for PostgreSQL console.
-
In the upper-left corner, select a region. On the Instances page, click the ID of the instance whose extensions you want to manage.
-
In the left-side navigation pane, click Extensions.
Install extensions
Install extensions from the Extensions page (recommended) or by submit a ticket if the extension you need is not listed.
Installing pg_hint_plan or pg_stat_statements triggers an automatic instance restart. During the restart, read and write operations are unavailable.
Install a single extension
-
On the Extensions page, find the extension and click Install in the Actions column.
-
In the Install Extension dialog box, select one database, multiple databases, or all databases, then click Install.
-
Wait 1–5 minutes for the instance status to change from Installing Extension back to Running, then verify that the extension status is Installed.
Batch install extensions
-
On the Extensions page, click Batch Install in the upper-left corner.
-
In the Batch Install Extensions dialog box, select the extensions and the target databases, then click Install.
-
Wait 1–5 minutes for the instance status to change from Installing Extension back to Running, then verify that each extension status is Installed.
Uninstall an extension
Uninstall extensions from the Extensions page (recommended) or by submitting a ticket if the extension is not listed.
Uninstalling an extension may cause data loss or service unavailability. Proceed with caution.
-
On the Extensions page, find the extension and click Uninstall in the Actions column.
-
In the Uninstall Extension dialog box, select one database or multiple databases, then click Uninstall.
-
On the Extensions page, verify that the extension has been removed.
Update an extension
On the Extensions page, find the extension and click Update in the Actions column.
Update is only available when the instance's current minor version supports a higher version of the extension. If Update is not shown, the extension is already at its latest version.
Update extensions during off-peak hours to minimize impact on running workloads.
Troubleshooting
ERROR: permission denied to create extension "uuid-ossp"
Cause: The uuid-ossp extension cannot be installed using a CREATE EXTENSION statement directly.
Solution: Install it from the Extensions page in the console instead.