Install, uninstall, update, and search for PostgreSQL extensions on an ApsaraDB RDS for PostgreSQL instance from the ApsaraDB RDS console.
Prerequisites
Before you begin, ensure that you have:
An RDS instance that runs PostgreSQL 10 or later
A minor engine version of 20230330 or later on the RDS instance. For more information, see Update the minor engine version
A primary RDS instance that uses Enterprise SSDs (ESSDs) or Premium ESSDs
At least one privileged account and a database created for the RDS instance. For more information, see Create a database and an account on an ApsaraDB RDS for PostgreSQL instance
Usage notes
If the extension requires preloading via the shared_preload_libraries parameter and the extension name is not already in the parameter value, installing the extension automatically restarts the RDS instance. To check whether this applies, go to the Parameters page of the RDS instance and view the shared_preload_libraries configuration.
GanosBase extensions and PostGIS extensions cannot be installed in the same schema.
The following extensions require a privileged account. If you use a non-privileged account, the installation fails:
ganos_geometry_topologyganos_tiger_geocoderpostgis_tiger_geocoderpostgis_topology
Uninstalling an extension may cause data loss and service interruptions. Proceed with caution.
Procedure
Go to the Instances page. In the top navigation bar, select the region of the RDS instance. Find the RDS instance and click the instance ID.
In the left-side navigation pane, click Plug-ins.
The Plug-ins page provides two tabs: Extension Marketplace and Extension Management.
Install an extension
Use one of the following methods to install an extension.
From the Extension Marketplace tab
Click the Extension Marketplace tab to view popular extensions.
Find the target extension and click Install in the Actions column.
From the Extension Management tab
Click the Extension Management tab and specify the database whose extensions you want to manage.
Click the Uninstalled Extensions tab.
Find the target extension and click Install in the Actions column.
Select multiple extensions to install them at a time.
Uninstall an extension
Uninstalling an extension may cause data loss and service interruptions. Proceed with caution.
On the Extension Management tab, specify the database whose extensions you want to manage.
Click the Installed Extensions tab.
Find the target extension and click Uninstall in the Actions column.
Select multiple extensions to uninstall them at a time.
Update an extension
On the Extension Management tab, specify the database whose extensions you want to manage.
Click the Installed Extensions tab.
Find the target extension and click Upgrade Version in the Actions column.
If Upgrade Version is not displayed in the Actions column, the extension already runs the latest version.
Search for extensions
On the Extension Management tab, specify the database whose extensions you want to manage.
Use Filter by extension to search for extensions by feature. Select multiple features to narrow results.
Apply extensions to another database
On the Extension Management tab, specify the database whose extensions you want to manage.
Click the Installed Extensions tab.
Click Apply to Other Databases to install all extensions from the current database on another database.
API reference
| Operation | Description |
|---|---|
| CreatePostgresExtensions | Creates an extension for a database. If the extension is not created after the operation succeeds, check whether the major engine version of the RDS instance supports the extension. For more information, see Extensions supported by ApsaraDB RDS for PostgreSQL. |
| DescribePostgresExtensions | Queries extensions installed on a database. |
| UpdatePostgresExtensions | Updates the version of an extension on a database. |
| DeletePostgresExtensions | Deletes an extension from a database. |