docs/deploy/self-hosted/extension.mdx
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.
Ensure that you have superuser access to the Postgres database.
ParadeDB provides prebuilt binaries of our extension for Postgres 15+ on:
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.
<Note> You can replace `0.23.3` with the `pg_search` version you wish to install and `17` with the version of Postgres you are using. </Note> <CodeGroup># Available arch versions are amd64, arm64
curl -L "https://github.com/paradedb/paradedb/releases/download/v0.23.3/postgresql-17-pg-search_0.23.3-1PARADEDB-noble_amd64.deb" -o /tmp/pg_search.deb
sudo apt-get install -y /tmp/*.deb
# Available arch versions are amd64, arm64
curl -L "https://github.com/paradedb/paradedb/releases/download/v0.23.3/postgresql-17-pg-search_0.23.3-1PARADEDB-jammy_amd64.deb" -o /tmp/pg_search.deb
sudo apt-get install -y /tmp/*.deb
# Available arch versions are amd64, arm64
curl -L "https://github.com/paradedb/paradedb/releases/download/v0.23.3/postgresql-17-pg-search_0.23.3-1PARADEDB-trixie_amd64.deb" -o /tmp/pg_search.deb
sudo apt-get install -y /tmp/*.deb
# Available arch versions are amd64, arm64
curl -L "https://github.com/paradedb/paradedb/releases/download/v0.23.3/postgresql-17-pg-search_0.23.3-1PARADEDB-bookworm_amd64.deb" -o /tmp/pg_search.deb
sudo apt-get install -y /tmp/*.deb
# Available arch versions are x86_64, aarch64
curl -L "https://github.com/paradedb/paradedb/releases/download/v0.23.3/pg_search_17-0.23.3-1PARADEDB.el10.x86_64.rpm" -o /tmp/pg_search.rpm
sudo dnf install -y /tmp/*.rpm
# Available arch versions are x86_64, aarch64
curl -L "https://github.com/paradedb/paradedb/releases/download/v0.23.3/pg_search_17-0.23.3-1PARADEDB.el9.x86_64.rpm" -o /tmp/pg_search.rpm
sudo dnf install -y /tmp/*.rpm
# Available arch version is arm64
curl -L "https://github.com/paradedb/paradedb/releases/download/v0.23.3/[email protected]_sequoia.pkg" -o ~/Downloads/pg_search.pkg
sudo installer -pkg ~/Downloads/pg_search.pkg -target /
# Available arch version is arm64
curl -L "https://github.com/paradedb/paradedb/releases/download/v0.23.3/[email protected]_sonoma.pkg" -o ~/Downloads/pg_search.pkg
sudo installer -pkg ~/Downloads/pg_search.pkg -target /
If you are a ParadeDB Enterprise user, you should have received a copy of the enterprise binaries. Please contact sales for access.
postgresql.confNext, 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.
Finally, connect to your Postgres database via your client of choice (e.g. psql) and run the following command:
CREATE EXTENSION pg_search;