How to install the additional module pg_trgm

Question

I just want to know how to install the module pg_tgrm as used in the trigram indexing scheme that allows you to do un-anchored search patterns on an index.

WHERE foo LIKE '%bar%';

score 84 · Accepted Answer · edited Jan 22 '23 at 07:34

pg_trgm is an extension, so:

CREATE EXTENSION pg_trgm;

If you get the following error

ERROR: could not open extension control file ".../extension/pg_trgm.control":
No such file or directory"

then you need to install the module for your operating system. For example:

Ubuntu/Debian:
```
  sudo apt install postgresql-contrib
```

Redhat/Centos

  sudo dnf install postgresql12-contrib

Fedora
```
  sudo dnf install postgresql-contrib
```

FreeBSD

  sudo pkg install postgresql12-contrib

Of course, "12" can be replaced with whatever version number is appropriate.

score 15 · Answer 2 · edited Sep 10 '19 at 10:33

15

1) Log into postgres

psql -U <DB_USERNAME>

2) After you are connected, switch to the DB you want to install the extension for:

\c <DB_NAME>

3) Then install the extension as answered previously:

CREATE EXTENSION pg_trgm;

Installing the extension initially gave me issues because I was not doing step 2. I thought the installation was a global thing but it seems its per DB

edited Sep 10 '19 at 10:33

Laurenz Albe

61,070
4
55
90

answered Aug 23 '19 at 15:30

Troy Porter

151
1
2

score 0 · Answer 3 · edited May 15 '20 at 18:23

0

To complete the answer of @Jendrusk for :

CentOs system you can also use

yum install postgresql-contrib

edited May 15 '20 at 18:23

Marcello Miorelli

17,274
53
180
320

answered May 15 '20 at 14:52

Soufyan Amenzou

1

How to install the additional module pg_trgm

3 Answers3