I have installed Postgres 9.5 in an attempt to install GitLab. As part of the process the trigram extension (pg_trgm) needs to be created on the database. When I issue the create statement I get the following error:

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

Presumably there was a version of Postgres 9.1 on the server previously and the extension control file is currently found at /usr/share/postgresql/9.5/extension/pg_trgm.control. How do I get the psql instance to see the extension in the 9.5 directory?

  • Have you checked if your postgres config(s) might still be pointing to the 9.1 directory? Did you also check what version of PG is in fact running currently? – iwaseatenbyagrue Apr 24 '17 at 17:03
  • The error was having some 9.1 and 9.3 packages still installed. I had tried removing the packages but apparently not gotten all of them. I don't know if this qualifies as an answer-worthy response. – FluxIX Apr 28 '17 at 2:40
  • This error can also occur if you're missing the postgresql-contrib package on ubuntu/debian. – amdfan Jun 8 '17 at 7:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.