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: