pg_search
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.
pg_search
can be combined with pgvector
for hybrid search. You can find
the instructions for installing pgvector
here.
Was this page helpful?