pg_search trigram extension not working

Question

Rails5, i have it installed on database

pg_trgm       | 1.1     | public     | text similarity measurement and index searching based on trigrams) 

and in the initializer :

PgSearch.multisearch_options = {
  :using => [:tsearch, :trigram],
}

i've tried it with only :trigram (not :tsearch), doesn't work, even after db:reset and rake pg_search:multisearch:rebuild[AllModels].

Am I missing a step?

Answer 1

I'm the author of pg_search.

Trigram search requires the pg_trgm extension.

See the pg_search README and the wiki page for Installing PostgreSQL Extensions for more details.