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?