Skip to main content
We recommend running ParadeDB Enterprise, not Community, in production to maximize uptime. See overview.
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 pg_search extension, which powers all of ParadeDB’s custom functionalities.

​
Prerequisites

Prebuilt binaries are compiled for modern CPUs: x86-64-v3 (Intel/AMD 2013+), ARMv8.2-A+RCpc (AWS Graviton 2+, Ampere Altra, 2020+), and Apple M1+ (2020+). Older CPUs are not supported.
Ensure that you have superuser access to the Postgres database.

​
Install the ParadeDB Postgres Extension

​
ParadeDB Community

ParadeDB provides prebuilt binaries of our extension for Postgres 15+ on:
  • Debian 12 (Bookworm) and 13 (Trixie)
  • Ubuntu 22.04 (Jammy) and 24.04 (Noble)
  • macOS 14 (Sonoma) and 15 (Sequoia)
  • Red Hat Enterprise Linux 9 and 10
If you are using a different version of Postgres or a different operating system, you will need to build the extension from source. The prebuilt releases can be found in GitHub Releases.
You can replace 0.22.6 with the pg_search version you wish to install and 17 with the version of Postgres you are using.
# Available arch versions are amd64, arm64
curl -L "https://github.com/paradedb/paradedb/releases/download/v0.22.6/postgresql-17-pg-search_0.22.6-1PARADEDB-noble_amd64.deb" -o /tmp/pg_search.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. 
shared_preload_libraries = 'pg_search'
Reload the Postgres server for these changes to take effect.

​
Load the Extension

Finally, connect to your Postgres database via your client of choice (e.g. psql) and run the following command: 
CREATE EXTENSION pg_search;
pg_search can be combined with pgvector for hybrid search. You can find the instructions for installing pgvector on the pgvector GitHub repository.