Installing and Uninstalling an Extension on the TaurusDB Console

Scenarios

TaurusDB for PostgreSQL allows you to install and uninstall extensions on the console.

TaurusDB for PostgreSQL extensions only take effect on the databases you created the extensions for. To use an extension on databases, it has to be created separately for each database.

Prerequisites

Before installing or uninstalling extensions, ensure that there are databases in your instance.

Precautions

• plpgsql is a built-in extension and cannot be uninstalled.
• Logical replication extensions, such as wal2json, can be used as-is. There is no installation required.
• Some extensions depend on the shared_preload_libraries parameter. They can be installed only after related libraries are loaded.
• Before using the pg_cron extension, change the value of cron.database_name to the name of the database this extension is used for (only one database is supported), and change the value of cron.use_background_workers to on.
• Installing or uninstalling some extensions will cause their dependent extensions and tables to be installed or uninstalled synchronously.

Modifying the shared_preload_libraries Parameter

Some extensions require corresponding parameter values to be loaded before the extensions can be installed.

You can modify the shared_preload_libraries parameter to load parameter values in batches or load each required parameter value independently before installing an extension.

1. Log in to the management console.
2. Click in the upper left corner and select a region.
3. Click in the upper left corner of the page and choose Databases > TaurusDB.
4. On the Instances page, click the instance name.
5. In the navigation pane, choose Plugins.
6. On the Plugins page, click next to Loaded shared_preload_libraries parameter values to view the loaded parameter values.
7. Click Change.
   Figure 1 Viewing loaded parameter values
   

8. Select the parameter values to be loaded from the drop-down list box and click OK.
   Figure 2 Selecting parameter values to be loaded
   

9. In the displayed dialog box, click OK.
   

   • The modified parameter values take effect only after the instance is rebooted.
   • To ensure security and O&M functions of TaurusDB for PostgreSQL, the following parameter values are loaded by default and cannot be deleted:
     • passwordcheck.so
     • pg_stat_statements
     • pg_sql_history
     • pgaudit

10. You can also load each parameter value independently before installing an extension.
    Figure 3 Loading a parameter value
    

Installing and Uninstalling an Extension

1. Log in to the management console.
2. Click in the upper left corner and select a region.
3. Click in the upper left corner of the page and choose Databases > TaurusDB.
4. On the Instances page, click the instance name.
5. In the navigation pane, choose Plugins.
6. In the Database drop-down list above the extension list, select the database where the extension is to be installed.
7. Locate the extension to be installed and click Install in the Operation column.
8. To uninstall an extension, click Uninstall.