Skip to main content
If you already manage your own Postgres cluster, the simplest way to adopt ParadeDB is to install the extension directly in your cluster.

Prerequisites

Ensure that you have superuser access to the Postgres database. As of 0.25.0, pg_search relies on pgvector’s vector type, making it a required extension. Follow the pgvector installation instructions to install it on the server before installing pg_search.

Installing the ParadeDB Postgres Extension

ParadeDB provides prebuilt binaries of our extension for Postgres 15+ on:
  • Debian 12 (Bookworm) and 13 (Trixie)
  • Ubuntu 24.04 (Noble) and 26.04 (Resolute)
  • Red Hat Enterprise Linux 9 and 10
  • macOS 15 (Sequoia) and 26 (Tahoe)
  • macOS via Postgres.app (Postgres 18 only)
The prebuilt releases can be found in GitHub Releases. To request access to prebuilt binaries for ParadeDB Enterprise, contact sales.
Packages are available for amd64 and arm64. Adjust the ParadeDB version, Postgres major version, and architecture in the download URL to match your setup.

Updating postgresql.conf

Next, add the extension to shared_preload_libraries in postgresql.conf.
Restart the Postgres server for these changes to take effect.

Loading the Extension

Finally, connect to your Postgres database and run the following command:
pg_search requires pgvector. CASCADE enables it in the database if it is not already enabled.