Installing the Trigram Module

This section covers installing the postgresql-contrib package available from your Linux distribution. In order to install it, the PostgreSQL user must have CREATE privileges on the current database. This can be granted using a command like the following:

grant create on database <database_name> to <database_user>;

After granting CREATE privileges for your database, you will then need to install the postgresql-contrib package available from your Linux distribution. For example, you might use the following for Fedora:

sudo dnf install postgresql-contrib

Once installed, execute the following command to create the extension. If your JDBC URL does not specify a schema, then use public:

create extension pg_trgm schema <schema>;

Once that is done, you should see the extension listed:

select * from pg_extension;

Once that is done, you should see the extension listed: