The pg_search extension powers all of ParadeDB’s full text search capabilities.

This guide explains how to install pg_search inside an existing PostgreSQL database. These instructions are for deploying on Linux Debian/Ubuntu. If you are using a different version of Linux, please contact us.

​

Prerequisites

First, ensure that you have superuser access to the Postgres database.

Next, install libicu.

# Ubuntu 20.04 or 22.04
sudo apt-get install -y libicu70

# Ubuntu 24.04
sudo apt-get install -y libicu74

​

Install pg_search

ParadeDB provides prebuilt binaries for the pg_search extension on Debian 12, Ubuntu 22.04 and 24.04, and Red Hat Enterprise Linux 8 and 9 for Postgres 14, 15 and 16 on both amd64 (x86_64) and arm64. They can be found in GitHub Releases. If you are using a different version of Postgres or a different operating system, you will need to build the extension from source.

​

Using Prebuilt Binaries

Note: You can replace v0.10.0 with the pg_search version you wish to install, and 16 with the version of Postgres you are using.

​

Building from Source

Please follow these instructions.

​

Update postgresql.conf

Next, add pg_search to shared_preload_libraries in postgresql.conf.

shared_preload_libraries = 'pg_search'

Reload your PostgreSQL server for these changes to take effect.

​

Load the Extension

Once the extension binary is installed on your system, connect to your Postgres database via your client of choice (e.g. psql) and run the following command:

CREATE EXTENSION pg_search;

That’s it! You’re all set to use pg_search in your database. To get started, we suggest you follow the quickstart guide.