Postgres extensions available by deployment
Categories of extensions:
Open source extensions
Virtual Machines/Physical Servers | Kubernetes | EDB Postgres AI Cloud Service | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Extension name | Requires superuser access | PostgreSQL | EDB Postgres Extended Server | EDB Postgres Advanced Server | PostgreSQL | EDB Postgres Advanced Server | PostgreSQL | EDB Postgres Extended Server | EDB Postgres Advanced Server | ||||
PostgreSQL Contrib Extensions/Modules | |||||||||||||
adminpack | Yes | ✓ | ✓ | ✓ | – | – | – | – | – | ||||
amcheck | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
auth_delay | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
auto_explain | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
bloom | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
btree_gin | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
btree_gist | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
citext | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
cube | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
dblink | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
dict_int | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
dict_xsyn | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
earthdistance | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
file_fdw | Yes | ✓ | ✓ | ✓ | – | – | – | – | – | ||||
fuzzystrmatch | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
hstore | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
hstore_plperl | Yes | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | ||||
hstore_plperlu | Yes | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | ||||
intagg | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
intarray | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
isn | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
jsonb_plperl | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | |||||
jsonb_plperlu | Yes | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | ||||
lo | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
ltree | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
old_snapshot | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
pageinspect | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
passwordcheck | ✓ | ✓ | ✓ | – | – | – | – | – | |||||
plpgsql | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
pg_buffercache | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
pg_freespacemap | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
pg_prewarm | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
pg_stat_statements | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
pg_surgery | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
pg_trgm | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
pg_visibility | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
pgcrypto | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
pgrowlocks | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
pgstattuple | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
postgres_fdw | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
seg | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
sepgsql | ✓ | ✓ | ✓ | – | – | – | – | – | |||||
spi | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
autoinc | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
insert_username | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
moddatetime | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
refint | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
sslinfo | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
tablefunc | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
tcn | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
test_decoding | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
tsm_system_rows | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
tsm_system_time | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
unaccent | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
uuid-ossp | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
xml2 | Yes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||
PostgreSQL Non-Contrib Extensions/Modules | |||||||||||||
ip4r | ✓ | – | – | – | – | – | – | – | |||||
orafce | ✓ | – | – | – | – | – | – | – | |||||
pg_cron | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | |||||
pg_failover_slots | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
pg_permissions | ✓ | – | – | – | – | – | – | – | |||||
pg_squeeze | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | |||||
pg_store_plans | ✓ | – | – | – | – | – | – | – | |||||
pgaudit | Yes | ✓ | ✓ | – | ✓ | – | ✓ | – | – | ||||
pglogical 2.x | ✓ | ✓ | ✓ | – | – | – | – | – | |||||
pgsnmpd (11-13) | ✓ | – | ✓ | – | – | – | – | – | |||||
pgvector | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | |||||
plperl | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | |||||
plperlu | Yes | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | ||||
bool_plperl | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | |||||
bool_plperlu | Yes | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | ||||
plpythonu (default is 2u for 11-14 and 3u for 15) | Yes | ✓ | ✓ | ✓ | – | – | – | – | – | ||||
hstore_plpythonu | Yes | ✓ | ✓ | ✓ | – | – | – | – | – | ||||
jsonb_plpythonu | Yes | ✓ | ✓ | ✓ | – | – | – | – | – | ||||
ltree_plpythonu | Yes | ✓ | ✓ | ✓ | – | – | – | – | – | ||||
plpython2u (11-14) | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | |||||
hstore_plpython2u | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | |||||
jsonb_plpython2u | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | |||||
ltree_plpython2u | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | |||||
plpython3u (11-15) | Yes | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | ||||
hstore_plpython3u | Yes | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | ||||
jsonb_plpython3u | Yes | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | ||||
ltree_plpython3u | Yes | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | ||||
pltcl | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | |||||
pltclu | Yes | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | ||||
plv8 | Yes | ✓ | – | – | – | – | – | – | – | ||||
pg global temporary tables (pgtt) | ✓ | ✓ | ✓ | – | – | – | – | – | |||||
set_user | ✓ | – | – | – | – | – | – | – | |||||
sslutils | ✓ | ✓ | ✓ | – | – | – | – | – | |||||
system_stats | ✓ | ✓ | ✓ | – | – | – | – | – | |||||
timescaledb | ✓ | – | – | – | – | – | – | – |
EDB extensions
Virtual Machines/Physical Servers | Kubernetes | EDB Postgres AI Cloud Service | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Extension name | Requires superuser access | PostgreSQL | EDB Postgres Extended Server | EDB Postgres Advanced Server | PostgreSQL | EDB Postgres Advanced Server | PostgreSQL | EDB Postgres Extended Server | EDB Postgres Advanced Server | ||||
edb_pg_tuner | ✓ | ✓ | ✓ | ✓ | ✓ | – | ✓ | ✓ | |||||
edb_query_advisor | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | |||||
edb_wait_states | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | |||||
sql_profiler | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | |||||
EDB Storage Pack | |||||||||||||
autocluster | ✓ | ✓ | ✓ | – | – | – | ✓ | ✓ | |||||
bluefin | ✓ | ✓ | ✓ | – | – | ✓ | ✓ | ✓ | |||||
refdata | ✓ | ✓ | ✓ | – | – | – | ✓ | ✓ | |||||
EDB Postgres Advanced Server extensions | |||||||||||||
dbms_job | – | – | ✓ | – | – | – | – | – | |||||
dbms_scheduler | – | – | ✓ | – | – | – | – | ✓ | |||||
edb_job_scheduler | – | – | ✓ | – | – | – | – | ✓ | |||||
edb_cloneschema | – | – | ✓ | – | – | – | – | – | |||||
edb_dblink_libpq | – | – | ✓ | – | ✓ | – | – | ✓ | |||||
edb_dblink_oci | Yes | – | – | ✓ | – | ✓ | – | – | ✓ | ||||
edb_dbo | Yes | – | – | ✓ | – | ✓ | – | – | ✓ | ||||
edbspl | Yes | – | – | ✓ | – | ✓ | – | – | ✓ | ||||
spl_check | – | – | ✓ | – | ✓ | – | – | ✓ | |||||
parallel_clone | – | – | ✓ | – | – | – | – | – | |||||
EDB Postgres Distributed extensions | |||||||||||||
bdr 4.x | ✓ | ✓ | ✓ | – | – | – | – | – | |||||
bdr 5.x | ✓ | ✓ | ✓ | Preview | Preview | – | Preview | Preview | |||||
pglogical 3.x | Yes | ✓ | ✓ | ✓ | – | – | – | – | – |
EDB supported open source extensions
Virtual Machines/Physical Servers | Kubernetes | EDB Postgres AI Cloud Service | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Extension name | Requires superuser access | PostgreSQL | EDB Postgres Extended Server | EDB Postgres Advanced Server | PostgreSQL | EDB Postgres Advanced Server | PostgreSQL | EDB Postgres Extended Server | EDB Postgres Advanced Server | ||||
Postgres Geospatial | |||||||||||||
pgrouting | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
postgis | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
postgis_raster | ✓ | ✓ | ✓ | ✓ | ✓ | – | – | – | |||||
postgis_sfcgal | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
postgis_tiger_geocoder | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
postgis_topology | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
address_standardizer | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
address_standardizer_data_us | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
Pgpool | |||||||||||||
pgpool_adm | ✓ | – | ✓ | – | – | – | – | – | |||||
pgpool_recovery | ✓ | – | ✓ | – | – | – | – | – | |||||
PLdebugger | |||||||||||||
pldbgapi | ✓ | – | ✓ | – | – | – | – | – | |||||
Foreign Data Wrappers | |||||||||||||
hdfs_fdw | Yes | ✓ | – | ✓ | – | – | – | – | – | ||||
mongo_fdw | Yes | ✓ | – | ✓ | – | – | – | – | ✓ | ||||
mysql_fdw | Yes | ✓ | – | ✓ | – | – | – | – | ✓ |
Could this page be better? Report a problem or suggest an addition!