All Products
Search

This Product

    PolarDB:Supported extensions

    Document Center

    PolarDB:Supported extensions

    Last Updated:Jun 18, 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 differ from those in the following table, upgrade the minor engine version to the latest version.

    • This page lists only the most common extensions. To query all supported extensions, you can run the SELECT * FROM pg_available_extensions; command in your database.

    • Before you can use certain extensions, you must add them to the shared_preload_libraries parameter. Otherwise, you cannot create these extensions.

      • These extensions include 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.

    • To modify the shared_preload_libraries parameter, see Set cluster parameters.

    • If you receive a permission denied error (ERROR: permission denied for database postgres) when creating an extension, such as ganos_spatialref, in the default postgres database, switch to a database that you own and create the extension there.

    • If an extension fails to install but is listed as supported when you run the SELECT * FROM pg_available_extensions; command, submit a ticket for assistance.

    Important

    The support policy for PolarDB for PostgreSQL extensions was adjusted. Effective April 27, 2023, certain extensions can be created only on specific minor engine versions. This change does not affect existing extensions. For more information, see Restrictions on creating some PolarDB for PostgreSQL extensions on earlier minor engine versions starting from 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 U.S. data for address standardization.

    AGE

    -

    -

    1.5.1

    1.5.0

    1.5.0

    -

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

    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 an example of a GIN operator class that implements B-tree equivalent behavior for multiple data types and all enum types.

    btree_gist

    1.8

    1.7

    1.7

    1.7

    1.6.1

    1.5

    Provides an example of a GiST operator class that implements B-tree equivalent behavior for multiple 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

    Table operations 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

    An example of an add-on full-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 U.S. data extension for placename standardization 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

    Used for fast rendering 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 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 (PVs) and unique visitors (UVs).

    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

    You can 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 support for IP address range types in PostgreSQL.

    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

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

    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 bigram (2-gram) GIN index to accelerate the full-text search process.

    pg_buffercache

    1.6

    1.6

    1.6

    1.4

    1.5

    1.3

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

    polar_concurrency_control

    -

    -

    1.0

    -

    1.0

    1.0

    Used for concurrency control of SQL statements.

    polar_tde_utils

    1.0

    1.0

    1.0

    -

    1.0

    1.0

    An extension for batch encryption and decryption in TDE.

    pg_cron

    1.5

    1.5

    1.5

    1.5

    1.5

    1.2

    You can set a scheduled task.

    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 tokenization for full-text search.

    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 you change the default execution plan of PostgreSQL using hints in special comments.

    pg_profile

    -

    4.10

    4.10

    4.10

    4.1

    1.0

    Collects 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

    Collects 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 searching 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 network types.

    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 debugger 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 universally unique identifier (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 and 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 multiple 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.