Extensions

If you already self-manage Postgres, you may prefer to install ParadeDB directly within your self-managed Postgres instead of deploying the ParadeDB Helm chart.

This can be done by installing the two extensions that ParadeDB uses:

• The pg_search extension powers all of ParadeDB’s full text search and analytics.
• The pg_analytics extension powers ParadeDB’s integrations.

​

Prerequisites

Ensure that you have superuser access to the Postgres database.

Next, install libicu.

sudo apt-get install -y libicu70

​

Install the ParadeDB Postgres Extensions

​

ParadeDB Community

ParadeDB provides prebuilt binaries for our extensions on

• Debian 12
• Ubuntu 22.04 and 24.04
• Red Hat Enterprise Linux 8 and 9
• macOS 14 (Sonoma) and 15 (Sequoia)

Postgres 14, 15, 16, and 17 are available. If you are using a different version of Postgres or a different operating system, you will need to build the extensions from source.

​

pg_search

The prebuilt releases can be found in GitHub Releases.

# Available arch versions are amd64, arm64
curl -L "https://github.com/paradedb/paradedb/releases/download/v0.15.5/postgresql-17-pg-search_0.15.5-1PARADEDB-noble_amd64.deb" -o /tmp/pg_search.deb
sudo apt-get install -y /tmp/*.deb

​

pg_analytics

The prebuilt releases can be found in GitHub Releases.

# Available arch versions are amd64, arm64
curl -L "https://github.com/paradedb/pg_analytics/releases/download/v0.3.4/postgresql-17-pg-analytics_0.3.4-1PARADEDB-noble_amd64.deb" -o /tmp/pg_analytics.deb
sudo apt-get install -y /tmp/*.deb

​

ParadeDB Enterprise

If you are a ParadeDB Enterprise user, you should have received a copy of the enterprise binaries. Please contact sales for access.

​

Update postgresql.conf

Next, add the extension(s) to shared_preload_libraries in postgresql.conf. Adding pg_search to shared_preload_libraries is unnecessary if your Postgres version is 17 or higher.

shared_preload_libraries = 'pg_search,pg_analytics'

Reload the Postgres server for these changes to take effect.

​

Load the Extensions

Finally, connect to your Postgres database via your client of choice (e.g. psql) and run the following command:

CREATE EXTENSION pg_search;
CREATE EXTENSION pg_analytics;