All Products
Search

This Product

    PolarDB:Supported extensions

    Document Center

    PolarDB:Supported extensions

    Last Updated:Jan 31, 2026

    This topic lists the extensions and their versions supported by different versions of PolarDB for PostgreSQL.

    Note

    • If the features supported by your cluster do not match the following table, upgrade the minor engine version to the latest version.

    • This page lists only common extensions. To check for more supported extensions, run the SELECT * FROM pg_available_extensions; command in your database.

    • Some extensions must be added to the shared_preload_libraries parameter before you can create them.

      • These extensions include the following: pg_stat_statements, auth_delay, passwordcheck, auto_explain, pgaudit, pg_bigm, pg_cron, pg_hint_plan, pg_prewarm, zhparser, timescaledb, pldebugger, and pg_jieba.

      • When you add the pldebugger extension to the shared_preload_libraries parameter, set the value to plugin_debugger.

    • For more information about how to modify the shared_preload_libraries parameter, see Set cluster parameters.

    • When you create some extensions, such as ganos_spatialref, in the default postgres database, you may receive a permission denied error (ERROR: permission denied for database postgres). If this occurs, switch to a database that your current account owns and create the extension there.

    • If an extension fails to install but the SELECT * FROM pg_available_extensions; command shows that your cluster supports it, submit a ticket.

    Important

    The extension support policy for PolarDB for PostgreSQL was adjusted. Starting from April 27, 2023, some extensions can be created only on specific minor engine versions. The use of existing extensions is not affected. For more information, see Creation of some PolarDB for PostgreSQL extensions is restricted on earlier minor engine versions since April 27, 2023.

    X86 architecture clusters

    Extension name

    PolarDB for PostgreSQL

    Description

    18

    17

    16

    15

    14

    11

    address_standardizer

    3.3.7

    3.3.7

    3.3.7

    3.3.7

    3.3.7

    3.3.4

    Provides address standardization.

    address_standardizer_data_us

    3.3.7

    3.3.7

    3.3.7

    3.3.7

    3.3.7

    3.3.4

    Provides address standardization data for the United States.

    AGE

    -

    -

    1.5.1

    1.5.0

    1.5.0

    -

    A graph extension for databases that uses the Cypher language to query graphs in the database.

    bloom

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    Provides an index access method based on Bloom filters.

    btree_gin

    1.3

    1.3

    1.3

    1.3

    1.3.1

    1.3

    Provides a sample GIN operator class that implements B-tree equivalent behavior for various data types and all enum types.

    btree_gist

    1.8

    1.7

    1.7

    1.7

    1.6.1

    1.5

    Provides a sample GiST operator class that implements B-tree equivalent behavior for various data types and all enum types.

    citext

    1.8

    1.6

    1.6

    1.6

    1.6

    1.5

    Provides a case-insensitive string type.

    cube

    1.5

    1.5

    1.5

    1.5

    1.5

    1.4

    Provides a data type for representing multidimensional cubes.

    dblink

    1.2

    1.2

    1.2

    1.2

    1.2

    1.2

    Operates on tables across databases.

    decoderbufs

    0.1.0

    0.1.0

    0.1.0

    0.1.0

    0.1.0

    0.1.0

    Outputs data compatible with the Debezium platform based on the Protocol Buffers protocol.

    dict_int

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    A sample text search dictionary template.

    earthdistance

    1.2

    1.2

    1.2

    1.1

    1.1

    1.1

    Provides two different methods to calculate great-circle distances on the surface of the Earth.

    fuzzystrmatch

    1.2

    1.2

    1.2

    1.1

    1.1

    1.1

    Determines the similarity and distance between strings.

    ganos_address_standardizer

    7.8

    7.7

    7.9

    7.7

    7.9

    6.8

    A placename standardization extension based on the PAGC standard.

    ganos_address_standardizer_data_us

    7.8

    7.7

    7.9

    7.7

    7.9

    6.8

    A placename standardization extension for U.S. data based on the PAGC standard.

    ganos_geometry

    7.8

    7.7

    7.9

    7.7

    7.9

    6.8

    Provides computing and analysis features for spatial geometry types.

    ganos_geometry_pyramid

    7.8

    7.7

    7.9

    7.7

    7.9

    6.8

    Provides fast display of 2D spatial geometry big data.

    ganos_geometry_sfcgal

    7.8

    7.7

    7.9

    7.7

    7.9

    6.8

    Provides extension features for the sfcgal spatial geometry extension.

    ganos_geometry_topology

    7.8

    7.7

    7.9

    7.7

    7.9

    6.8

    Provides computing and analysis features for spatial geometry types.

    ganos_networking

    7.8

    7.7

    7.9

    7.7

    7.9

    6.8

    Provides computing and analysis features for spatial geometry network types.

    ganos_pointcloud

    7.8

    7.7

    7.9

    7.7

    7.9

    6.8

    Provides storage, computing, and analysis features for point clouds.

    ganos_pointcloud_geometry

    7.8

    7.7

    7.9

    7.7

    7.9

    6.8

    Provides storage, computing, and analysis features for point clouds.

    ganos_raster

    7.8

    7.7

    7.9

    7.7

    7.9

    6.8

    Provides storage, computing, and analysis features for spatial raster data.

    ganos_spatialref

    7.8

    7.7

    7.9

    7.7

    7.9

    6.8

    Provides computing and analysis features for spatial references.

    ganos_tiger_geocoder

    7.8

    7.7

    7.9

    7.7

    7.9

    6.8

    Provides support for the U.S. Census Bureau (USCB) TIGER data type.

    ganos_trajectory

    7.8

    7.7

    7.9

    7.7

    7.9

    6.8

    Provides computing and analysis features for Ganos moving object data (MOD).

    hll

    2.18

    2.18

    2.18

    2.18

    2.17

    2.17

    Quickly estimates business metrics such as page views (PV) and unique visitors (UV).

    hstore

    1.8

    1.8

    1.8

    1.8

    1.8

    1.5

    Stores key-value pairs within a single PostgreSQL value.

    hypopg

    1.4.0

    -

    1.4.0

    1.3.1

    1.4.0

    1.3.1

    Create a virtual index.

    imgsmlr

    -

    -

    1.0

    -

    1.0

    -

    Supports similar image search.

    intagg

    1.1

    1.1

    1.1

    1.1

    1.1

    1.1

    Provides an integer aggregator and an enumerator.

    intarray

    1.5

    1.5

    1.5

    1.5

    1.5

    1.2

    Provides useful functions and operators to manipulate integer arrays that do not contain null values.

    ip4r

    2.4

    2.4

    2.4

    2.4

    2.4

    2.4

    Enables PostgreSQL to support IP address range types.

    isn

    1.3

    1.2

    1.2

    1.2

    1.2

    1.2

    Validates input against a hard-coded prefix list and is also used to join numbers on output.

    ltree

    1.3

    1.3

    1.2

    1.2

    1.2

    1.1

    Represents labels for data stored in a hierarchical tree-like structure.

    mysql_fdw

    1.2

    1.2

    1.2

    1.2

    1.2

    1.1

    Reads and writes data in MySQL databases.

    oss_fdw

    -

    -

    1.1

    -

    1.1

    1.1

    Reads and writes data in OSS.

    pase

    0.0.1

    0.0.1

    0.0.1

    0.0.1

    0.0.1

    0.0.1

    Provides efficient vector retrieval.

    pg_bigm

    1.2

    1.2

    1.2

    1.2

    1.2

    1.2

    Creates a 2-gram GIN index to accelerate full-text search.

    pg_buffercache

    1.6

    1.6

    1.6

    1.4

    1.5

    1.3

    Provides a way to inspect the shared buffer in real time.

    polar_concurrency_control

    -

    -

    1.0

    -

    1.0

    1.0

    Provides concurrency control for SQL statements.

    polar_tde_utils

    1.0

    1.0

    1.0

    -

    1.0

    1.0

    A TDE extension for batch encryption and decryption.

    pg_cron

    1.5

    1.5

    1.5

    1.5

    1.5

    1.2

    Sets scheduled tasks.

    pg_freespacemap

    1.3

    1.2

    1.2

    1.2

    1.2

    1.2

    Examines the free space map (FSM).

    pg_jieba

    1.1.0

    1.1.0

    1.1.0

    1.1.0

    1.1.0

    1.1.0

    Provides Chinese full-text tokenization.

    pg_pathman

    -

    -

    -

    -

    1.5

    1.5

    A high-performance partitioned table extension.

    pg_hint_plan

    -

    -

    1.6.2

    -

    1.4.1

    1.3.7

    Lets PostgreSQL change its execution plan based on hints in special comments.

    pg_profile

    -

    4.10

    4.10

    4.10

    4.1

    1.0

    Gathers statistics on resource-intensive activities.

    pg_prewarm

    1.2

    1.2

    1.2

    1.2

    1.2

    1.2

    Provides a convenient way to load data into the operating system buffer or the PostgreSQL buffer.

    pg_sphere

    -

    -

    1.0

    -

    1.0

    1.0

    Provides spherical data types, functions, operators, and indexes for PostgreSQL.

    pg_stat_kcache

    2.3.1

    2.3.0

    2.3.0

    2.3.0

    2.2.1

    2.2.1

    Gathers statistics on system read and write information.

    pg_stat_statements

    1.12

    1.11

    1.10.1

    1.10

    1.9.2

    1.6

    Provides a way to track execution statistics of all SQL statements executed by a server.

    pg_trgm

    1.6

    1.6

    1.6

    1.6

    1.6

    1.4

    Provides functions and operators for determining the similarity of alphanumeric text, and index operator classes that support fast searches for similar strings.

    pgaudit

    18.1

    17.1

    16.1

    1.7.1

    1.6.2

    1.3.3

    Provides detailed session and object audit logging.

    pgcrypto

    1.4

    1.3

    1.3

    1.3

    1.3

    1.3

    Provides cryptographic functions for PostgreSQL.

    pgrouting

    3.4.2

    3.4.2

    3.4.2

    3.4.2

    3.4.2

    3.4.2

    Provides computing and analysis features for spatial geometry networks.

    pgrowlocks

    1.2

    1.2

    1.2

    1.2

    1.2

    1.2

    Provides a function to display row lock information for a specified table.

    pgstattuple

    1.5

    1.5

    1.5

    1.5

    1.5

    1.5

    Provides various functions to obtain tuple-level statistics.

    pgvector

    0.8.0

    0.8.0

    0.8.0

    0.8.0

    0.8.0

    0.5.0

    An extension for high-dimensional vector similarity search.

    pldebugger

    1.1

    1.1

    1.1

    1.1

    1.1

    1.1

    A stored procedure debugging extension.

    plperl

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    Provides the Perl procedural language.

    plpgsql

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    Provides the SQL procedural language.

    pltcl

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    Provides the Tcl procedural language.

    postgis

    3.3.7

    3.3.7

    3.3.7

    3.3.7

    3.3.7

    3.3.4

    PostGIS extensions for spatial and geographic information.

    postgis_sfcgal

    3.3.7

    3.3.7

    3.3.7

    3.3.7

    3.3.7

    3.3.4

    PostGIS SFCGAL extensions for spatial and geographic information.

    postgis_tiger_geocoder

    3.3.7

    3.3.7

    3.3.7

    3.3.7

    3.3.7

    3.3.4

    PostGIS TIGER data extensions for spatial and geographic information.

    postgis_topology

    3.3.7

    3.3.7

    3.3.7

    3.3.7

    3.3.7

    3.3.4

    PostGIS topology data extensions for spatial and geographic information.

    q3c

    -

    -

    -

    -

    -

    2.0.0

    Used for spatial indexing on a sphere.

    rdkit

    -

    -

    -

    -

    -

    3.8

    Supports features such as cheminformatics and chemical molecule retrieval.

    roaringbitmap

    0.5

    0.5

    0.5

    0.5

    0.5

    0.5

    Uses bitmap features to improve query performance.

    rum

    1.3

    1.3

    1.3

    1.3

    1.3

    -

    Provides high-speed full-text search.

    sequential_uuid

    1.0.3

    1.0.3

    1.0.3

    1.0.3

    1.0.2

    1.0.2

    A UUID generator with a sequential pattern.

    smlar

    -

    -

    1.0

    -

    1.0

    1.0

    Calculates the similarity between two arrays of the same type.

    sslinfo

    1.2

    1.2

    1.2

    1.2

    1.2

    1.2

    Provides information about the SSL Certificate provided by the current client.

    tablefunc

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    Includes multiple functions that return tables.

    tds_fdw

    -

    -

    -

    -

    2.0.2

    2.0.2

    Queries data from other types of databases.

    timescaledb

    -

    -

    2.18.0

    -

    2.16.1

    1.7.1

    Supports automatic sharding, efficient writes, retrieval, and near-real-time aggregation for time series data.

    tsm_system_rows

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    Provides the SYSTEM_ROWS table sampling method.

    tsm_system_time

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    Provides the SYSTEM_TIME table sampling method.

    unaccent

    1.1

    1.1

    1.1

    1.1

    1.1

    1.1

    A text search dictionary that removes accents (diacritical marks) from lexemes.

    uuid-ossp

    1.1

    1.1

    1.1

    1.1

    1.1

    1.1

    Provides functions to generate universally unique identifiers (UUIDs) using one of several standard algorithms.

    varbitx

    1.1

    1.1

    1.1

    1.1

    1.1

    1.1

    Supports various bit operations.

    wal2json

    2.6

    2.6

    2.6

    2.6

    2.6

    2.5

    Outputs logical log files in JSON format.

    xml2

    1.2

    1.1

    1.1

    1.1

    1.1

    1.1

    Provides XPath query and XSLT features.

    zhparser

    2.2

    2.2

    2.2

    2.2

    1.0

    1.0

    Provides Chinese full-text search.

    zombodb

    -

    -

    -

    -

    -

    4.0

    Provides powerful text indexing and analysis features.