Dependencies

PostgreSQL extensions with dependency relationships

85 extensions depend on other extensions, 57 extensions are depended upon by others.

Upstream Dependencies

The following 85 extensions require other extensions to be installed first:

Extension	Requires	Description
`timeseries`	`pg_cron` `pg_partman`	Convenience API for time series stack
`periods`	`btree_gist`	Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
`emaj`	`dblink` `btree_gist`	Enables fine-grained write logging and time travel on subsets of the database.
`table_version`	`plpgsql`	PostgreSQL table versioning extension
`pg_later`	`pgmq`	Run queries now and get results later
`postgis_topology`	`postgis`	PostGIS topology spatial types and functions
`postgis_raster`	`postgis`	PostGIS raster types and functions
`postgis_sfcgal`	`postgis`	PostGIS SFCGAL functions
`postgis_tiger_geocoder`	`postgis` `fuzzystrmatch`	PostGIS tiger geocoder and reverse geocoder
`pgrouting`	`postgis`	pgRouting Extension
`pointcloud_postgis`	`postgis` `pointcloud`	integration for pointcloud LIDAR data and PostGIS geometry data
`h3_postgis`	`h3` `postgis` `postgis_raster`	H3 PostGIS integration
`geoip`	`ip4r`	IP-based geolocation query
`pg_eviltransform`	`postgis`	Coordinate transforms for BD09/GCJ02 via PostGIS ST_Transform
`mobilitydb`	`postgis`	MobilityDB geospatial trajectory data management & analysis platform
`mobilitydb_datagen`	`mobilitydb`	MobilityDB random data generator functions
`earthdistance`	`cube`	calculate great-circle distances on the surface of the Earth
`vchord`	`vector`	Vector database plugin for Postgres, written in Rust
`vectorscale`	`vector`	Advanced indexing for vector data with DiskANN
`vectorize`	`pg_cron` `pgmq` `vector`	The simplest way to do vector search on Postgres
`pg4ml`	`plpgsql` `tablefunc` `cube` `plpython3u`	Machine learning framework for PostgreSQL
`biscuit`	`plpgsql`	IAM-LIKE pattern matching with bitmap indexing
`pg_mooncake`	`pg_duckdb`	Columnstore Table in Postgres
`pg_incremental`	`pg_cron`	Incremental Processing by Crunchy Data
`pgmb`	`pg_cron` `http`	A simple PostgreSQL Message Broker system
`omni_auth`	`omni_types` `omni_id` `pgcrypto` `btree_gist` `omni_polyfill`	Basic session management
`omni_aws`	`omni_httpc` `pgcrypto` `omni_xml` `omni_web`	Amazon Web Services APIs (S3)
`omni_cloudevents`	`omni_web`	CloudEvents support
`omni_containers`	`omni_httpc` `omni_web`	Docker container management
`omni_credentials`	`pgcrypto` `omni_os`	Application credential management
`omni_email`	`omni_id` `omni_cloudevents` `omni_polyfill`	E-mail framework
`omni_httpc`	`omni_http` `omni_types`	HTTP client
`omni_httpd`	`omni_types` `omni_http`	HTTP server
`omni_kube`	`omni_httpc` `omni_web` `omni_var` `omni_yaml`	Kubernetes (k8s) integration
`omni_ledger`	`omni_id` `omni_polyfill`	Financial ledger
`omni_python`	`plpython3u`	First-class Python support
`omni_rest`	`omni_httpd` `omni_sql` `omni_web` `omni_var` `pgcrypto`	REST API toolkit (with PostgREST support)
`omni_schema`	`omni_sql` `omni_vfs` `omni_polyfill` `omni_yaml` `dblink` `postgres_fdw` `omni_types` `omni_cloudevents`	Advanced schema management tooling
`omni_session`	`omni_var` `omni_id` `omni_web` `omni_httpd` `omni_polyfill`	Session management
`omni_test`	`dblink` `omni_cloudevents`	Testing framework
`omni_vfs`	`omni_vfs_types_v1` `dblink`	Virtual File System
`hstore_pllua`	`hstore` `pllua`	Hstore transform for Lua
`hstore_plluau`	`hstore` `plluau`	Hstore transform for untrusted Lua
`plpgsql_check`	`plpgsql`	extended check for plpgsql functions
`plperl`	`plperl`	PL/Perl procedural language
`bool_plperl`	`plperl`	transform between bool and plperl
`hstore_plperl`	`plperl`	transform between hstore and plperl
`jsonb_plperl`	`plperl`	transform between jsonb and plperl
`plperlu`	`plperlu`	PL/PerlU untrusted procedural language
`bool_plperlu`	`plperlu`	transform between bool and plperlu
`jsonb_plperlu`	`plperlu`	transform between jsonb and plperlu
`hstore_plperlu`	`plperlu`	transform between hstore and plperlu
`jsonb_plpython3u`	`plpython3u`	transform between jsonb and plpython3u
`ltree_plpython3u`	`ltree` `plpython3u`	transform between ltree and plpython3u
`hstore_plpython3u`	`hstore` `plpython3u`	transform between hstore and plpython3u
`unit`	`plpgsql`	SI units extension
`pgfaceting`	`roaringbitmap`	fast faceting queries using an inverted index
`l10n_table_dependent_extension`	`pg_xenophile`	PostgreSQL l10n toolbox
`pgjwt`	`pgcrypto`	JSON Web Token API for Postgresql
`pg_readme`	`hstore`	Generate a README.md document for a database extension or schema
`pg_readme_test_extension`	`hstore`	Test generating a README.md document for extension or schema
`ddl_historization`	`plpgsql`	Historize the ddl changes inside PostgreSQL database
`data_historization`	`plpgsql`	PLPGSQL Script to historize data in partitionned table
`schedoc`	`ddl_historization`	Cross documentation between Django and DBT projects
`sparql`	`plperl` `plperlu`	Query SPARQL datasource with SQL
`pgautofailover`	`btree_gist`	pg_auto_failover
`pg_upless`	`plpgsql`	Detect Useless UPDATE
`pg_drop_events`	`plpgsql`	logs transaction ids of drop table, drop column, drop materialized view statements
`pg_profile`	`dblink` `plpgsql`	PostgreSQL load profile repository and report builder
`pg_stat_kcache`	`pg_stat_statements`	Kernel statistics gathering
`pg_sqlog`	`file_fdw`	Provide SQL interface to logs
`powa`	`plpgsql` `pg_stat_statements` `btree_gist`	PostgreSQL Workload Analyser-core
`supabase_vault`	`pgsodium`	Supabase Vault Extension
`pg_jobmon`	`dblink`	Extension for logging and monitoring functions in PostgreSQL
`pgcryptokey`	`pgcrypto`	cryptographic key management
`documentdb`	`documentdb_core` `pg_cron` `tsm_system_rows` `vector` `postgis` `rum`	API surface for DocumentDB for PostgreSQL
`documentdb_distributed`	`citus` `documentdb_core` `documentdb`	Multi-Node API surface for DocumentDB
`ora_btree_gin`	`ivorysql_ora`	Support for indexing oracle datatypes in GIN
`ora_btree_gist`	`ivorysql_ora`	Support for oracle indexing common datatypes in GiST
`pg_utl_smtp`	`plperlu`	Oracle UTL_SMTP compatibility extension for PostgreSQL
`babelfishpg_tsql`	`babelfishpg_common` `uuid-ossp`	SQL Server Transact SQL compatibility
`babelfishpg_tds`	`babelfishpg_tsql`	SQL Server TDS protocol extension
`pglogical_ticker`	`pglogical`	Have an accurate view on pglogical replication delay
`pgl_ddl_deploy`	`pglogical`	automated ddl deployment using pglogical
`mimeo`	`dblink`	Extension for specialized, per-table replication between PostgreSQL instances

Downstream Dependencies

The following 57 extensions are depended upon by other extensions:

Extension	Required By	Description
`pg_cron`	`documentdb` `pg_incremental` `timeseries` `vectorize` `pgmb`	Job scheduler for PostgreSQL
`postgis`	`documentdb` `h3_postgis` `mobilitydb` `pgrouting` `pointcloud_postgis` `postgis_raster` `postgis_sfcgal` `postgis_tiger_geocoder` `postgis_topology`	PostGIS geometry and geography spatial types and functions
`postgis_raster`	`h3_postgis`	PostGIS raster types and functions
`pointcloud`	`pointcloud_postgis`	data type for lidar point clouds
`h3`	`h3_postgis`	H3 bindings for PostgreSQL
`mobilitydb`	`mobilitydb_datagen`	MobilityDB geospatial trajectory data management & analysis platform
`vector`	`documentdb` `vchord` `vectorize` `vectorscale`	vector data type and ivfflat and hnsw access methods
`fuzzystrmatch`	`postgis_tiger_geocoder`	determine similarities and distance between strings
`citus`	`documentdb_distributed`	Distributed PostgreSQL as an extension
`pg_duckdb`	`pg_mooncake`	DuckDB Embedded in Postgres
`pg_partman`	`timeseries`	Extension to manage partitioned tables by time or ID
`tablefunc`	`pg4ml`	functions that manipulate whole tables, including crosstab
`rum`	`documentdb`	RUM index access method
`pgmq`	`pg_later` `vectorize`	A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
`omni_cloudevents`	`omni_email` `omni_schema` `omni_test`	CloudEvents support
`omni_http`	`omni_httpc` `omni_httpd`	Basic HTTP types
`omni_httpc`	`omni_aws` `omni_containers` `omni_kube`	HTTP client
`omni_httpd`	`omni_rest` `omni_session`	HTTP server
`omni_id`	`omni_auth` `omni_email` `omni_ledger` `omni_session`	Identity types
`omni_os`	`omni_credentials`	Operating system integration
`omni_polyfill`	`omni_auth` `omni_email` `omni_ledger` `omni_schema` `omni_session`	Postgres API polyfills
`omni_sql`	`omni_rest` `omni_schema`	Programmatic SQL manipulation
`omni_types`	`omni_auth` `omni_httpc` `omni_httpd` `omni_schema`	Advanced types
`omni_var`	`omni_kube` `omni_rest` `omni_session`	Scoped variables
`omni_vfs`	`omni_schema`	Virtual File System
`omni_vfs_types_v1`	`omni_vfs`	Virtual File System types (v1)
`omni_web`	`omni_aws` `omni_cloudevents` `omni_containers` `omni_kube` `omni_rest` `omni_session`	Common web stack primitives
`omni_xml`	`omni_aws`	XML toolkit
`omni_yaml`	`omni_kube` `omni_schema`	YAML toolkit
`pllua`	`hstore_pllua`	Lua as a procedural language
`plluau`	`hstore_plluau`	Lua as an untrusted procedural language
`plperl`	`bool_plperl` `hstore_plperl` `jsonb_plperl` `plperl` `sparql`	PL/Perl procedural language
`plperlu`	`bool_plperlu` `hstore_plperlu` `jsonb_plperlu` `plperlu` `pg_utl_smtp` `sparql`	PL/PerlU untrusted procedural language
`plpgsql`	`data_historization` `ddl_historization` `pg4ml` `pg_drop_events` `pg_profile` `pg_upless` `plpgsql_check` `powa` `table_version` `unit` `biscuit`	PL/pgSQL procedural language
`plpython3u`	`hstore_plpython3u` `jsonb_plpython3u` `ltree_plpython3u` `omni_python` `pg4ml`	PL/Python3U untrusted procedural language
`roaringbitmap`	`pgfaceting`	support for Roaring Bitmaps
`pg_xenophile`	`l10n_table_dependent_extension`	More than the bare necessities for PostgreSQL i18n and l10n.
`ip4r`	`geoip`	IPv4/v6 and IPv4/v6 range index type for PostgreSQL
`cube`	`earthdistance` `pg4ml`	data type for multidimensional cubes
`ltree`	`ltree_plpython3u`	data type for hierarchical tree-like structures
`hstore`	`hstore_pllua` `hstore_plluau` `hstore_plpython3u` `pg_readme` `pg_readme_test_extension`	data type for storing sets of (key, value) pairs
`ddl_historization`	`schedoc`	Historize the ddl changes inside PostgreSQL database
`tsm_system_rows`	`documentdb`	TABLESAMPLE method which accepts number of rows as a limit
`uuid-ossp`	`babelfishpg_tsql`	generate universally unique identifiers (UUIDs)
`btree_gist`	`emaj` `omni_auth` `periods` `pgautofailover` `powa`	support for indexing common datatypes in GiST
`pg_stat_statements`	`pg_stat_kcache` `powa`	track planning and execution statistics of all SQL statements executed
`pgsodium`	`supabase_vault`	Postgres extension for libsodium functions
`pgcrypto`	`omni_auth` `omni_aws` `omni_credentials` `omni_rest` `pgcryptokey` `pgjwt`	cryptographic functions
`dblink`	`emaj` `mimeo` `omni_schema` `omni_test` `omni_vfs` `pg_jobmon` `pg_profile`	connect to other PostgreSQL databases from within a database
`file_fdw`	`pg_sqlog`	foreign-data wrapper for flat file access
`postgres_fdw`	`omni_schema`	foreign-data wrapper for remote PostgreSQL servers
`documentdb`	`documentdb_distributed`	API surface for DocumentDB for PostgreSQL
`documentdb_core`	`documentdb` `documentdb_distributed`	Core API surface for DocumentDB for PostgreSQL
`ivorysql_ora`	`ora_btree_gin` `ora_btree_gist`	Oracle Compatible extension on Postgres Database
`babelfishpg_common`	`babelfishpg_tsql`	SQL Server Transact SQL Datatype Support
`babelfishpg_tsql`	`babelfishpg_tds`	SQL Server Transact SQL compatibility
`pglogical`	`pgl_ddl_deploy` `pglogical_ticker`	PostgreSQL Logical Replication

Feedback

Was this page helpful?

Thanks for the feedback! Please let us know how we can improve.

Sorry to hear that. Please let us know how we can improve.

Last Modified 2026-03-12: add pg extension catalog (95749bf)