Postgres extensions available by deployment
Categories of extensions:
Open source extensions
| Virtual Machines/Physical Servers | Kubernetes | EDB Postgres® AI Hybrid Manager | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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_anonymizer | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
| 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 | ✓ | ✓ | – | – | – | – | – | – | |||||
| wal2json | ✓ | ✓ | ✓ | – | – | – | – | – | |||||
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_otel | ✓ | ✓ | ✓ | – | – | – | – | – | |||||
| 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 | – | – | ✓ | – | ||||||||