Help Center/ GaussDB/ User Guide/ Plug-in Management/ Enabling or Disabling a Plug-in
Updated on 2024-11-11 GMT+08:00

Enabling or Disabling a Plug-in

You can enable or disable plug-in extensions for a GaussDB instance. The PostGIS plug-in only supports the following extensions: postgis, postgis_sfcgal, postgis_raster, yukon_geomodel, yukon_geogridcoder, and postgis_topology.

Precautions

  • The plug-in extension enabling or disabling requests can be submitted repeatedly.
  • A single extension can be enabled or disabled for multiple user databases.
  • When enabling plug-in extensions, enable postgis first and then the other extensions.

Constraints

  • If the instance or node status is abnormal, the plug-in cannot be enabled or disabled.
  • Before using the PostGIS plug-in, check whether the values of enable_default_ustore_table and forbid_public_funcname_same_with_sysfunc are off. If their values are on, the plug-in cannot be used. You can change the parameter value to off on the console. For details, see Modifying GaussDB Instance Parameters.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner of the page and choose Databases > GaussDB.
  4. On the Instances page, click the name of the target instance to go to the Basic Information page.
  5. In the Configuration area, click Enable/Disable Plug-in.

    Figure 1 Enabling/Disabling a plug-in

  6. Set User Database, Extension, and Enable/Disable Plug-in, and click OK.

    Table 1 Parameter description

    Parameter

    Description

    User Database

    Select one or more user-created service databases.

    Extension

    Six types of expansions are supported. The available extensions displayed vary from instance to instance.

    • postgis
    • postgis_sfcgal
    • postgis_raster
    • yukon_geomodel
    • yukon_geogridcoder
    • postgis_topology

    Enable/Disable Plug-in

    Select Enable or Disable.