ApsaraDB RDS:Manage extensions

Prerequisites

• The instance runs PostgreSQL 10 or later.

• The instance uses minor engine version 20230330 or later. Update the minor engine version.

• The instance is a primary instance that uses an ESSD cloud disk or Premium ESSD.

• The instance has at least one privileged account and one database. Create an account and a database.

Usage notes

• Installing an extension that requires preloading via shared_preload_libraries but is not yet listed in this parameter triggers an automatic instance restart.

  Note

  Check the shared_preload_libraries parameter on the Parameters page to verify whether the extension is already listed.

• GanosBase and PostGIS extensions cannot be installed in the same schema.

• The following extensions require the target database to be owned by a privileged account. Otherwise, the installation will fail.

  ganos_geometry_topology, ganos_tiger_geocoder, postgis_tiger_geocoder, and postgis_topology.

• Uninstalling an extension may cause data loss and service interruptions.

Procedure

1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.

2. In the navigation pane on the left, click Plug-ins.

   • The Extension Marketplace page lists popular extensions available for installation.

     • Click Install next to the desired extension.

   • On the Extension Management page, select a database.

     • Filter extensions

       Use the Filter by extension menu to filter by feature. You can select multiple options.

     • Install extensions

       On the Uninstalled Extensions tab, find the target extension and click Install in the Actions column.

       You can select and install multiple extensions at once.

     • Uninstall extensions

       On the Installed Extensions tab, find the target extension and click Uninstall in the Actions column.

       You can select and uninstall multiple extensions at once.

       Important

       Uninstalling an extension may cause data loss and service interruptions.

     • Upgrade extensions

       On the Installed Extensions tab, find the target extension and click Upgrade Version in the Actions column.

       Note

       If Upgrade Version is unavailable in the Actions column, the extension is already up to date.

     • Apply extensions to other databases

       On the Installed Extensions tab, click Apply to Other Databases to install all of the current database's extensions on other databases.

Related APIs

Join the DingTalk group (ID: 103525002795) for RDS PostgreSQL extension discussions and feedback.