Prerequisites
Ensure that you have superuser access to the Postgres database. As of0.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)
- Debian
- Ubuntu
- RHEL
- macOS
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.
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.