All geek questions in one place

How to install Trigram module for Postgresql installed via homebrew?

So, I installed Postgresql via Homebrew, and it looks like the contrib directory is missing. And all the tutorials that I read to install Trigram require this.

$ cd /usr/local/Cellar/postgresql/9.1.2/share/postgresql/contrib -bash: cd: /usr/local/Cellar/postgresql/9.1.2/share/postgresql/contrib: No such file or directory

Can someone point me in the right direction to install Trigram (pg_trgm.sql)? I'm lost here.

Thanks.

+4
source share
2 answers

It just turned out that the right way ...

 /usr/local/Cellar/postgresql/9.1.2/share/postgresql/extension

Want to share with those who are still working on this.

+5
source

I ran the same problem, but found that the correct path was:

 /usr/local/Cellar/postgis15/1.5.3/share/postgis/

Of course, check your PostGIS version number according to your exact path. Files found in this folder, such as postgis.sql or spaces_ref_sys.sql ... I think this is what you need?

0
source

Source: https://habr.com/ru/post/1403754/

More articles:


All Articles