Install Extension
This section of the guide describes how to install extensions.
See the list of 400+ extensions available for installation, but you’re not limited to it—you can install any extension through various methods, including building from source.
Console (UI)
Extension installation is currently supported only through the command line.
If you’re interested in having this functionality available through the UI, please consider becoming a sponsor.
Command line
Method 1: Auto-Setup
This feature simplifies the installation of popular PostgreSQL extensions by automating setup and configuration.
It adds repositories, installs packages, and sets parameters like shared_preload_libraries as needed for seamless integration.
List of extensions supported in “Auto-Setup” mode:
Extension | Description | Variable |
---|---|---|
timescaledb | Enables scalable inserts and complex queries for time-series data. Provided by Timescale | enable_timescaledb |
citus | Distributed PostgreSQL as an extension | enable_citus |
pg_search | Full text search for PostgreSQL using BM25. Provided by ParadeDB | enable_pg_search or enable_paradedb |
pg_analytics | Postgres for analytics, powered by DuckDB. Provided by ParadeDB | enable_pg_analytics or enable_paradedb |
vector | pgvector: vector data type and ivfflat and hnsw access methods | enable_pgvector |
vectorscale | pgvectorscale: Advanced indexing for vector data | enable_pgvectorscale |
postgis | PostGIS geometry and geography spatial types and functions | enable_postgis |
pgrouting | Routing extension for PostGIS | enable_pgrouting |
pg_cron | Job scheduler for PostgreSQL | enable_pg_cron |
pgaudit | PostgreSQL Audit Extension | enable_pgaudit |
pg_partman | Partition management extension for PostgreSQL | enable_pg_partman |
pg_repack | Reorganize tables in PostgreSQL databases with minimal locks | enable_pg_repack |
pg_stat_kcache | Gather statistics about physical disk access and CPU consumption done by backends | enable_pg_stat_kcache |
pg_wait_sampling | Sampling based statistics of wait events | enable_pg_wait_sampling |
Enable the following extensions by setting the respective variables to true
, example:
ansible-playbook deploy_pgcluster.yml -e "enable_timescaledb=true"