[Migrate] Error executing migration for version 10 : pq: 'gin' access method is not supported

Author Topic
mysh

Posted on

GIN (Generalized Inverted Index) is used for the global search feature. It was introduced in version 1.11, in migration #10.

To enable it run the following:

CREATE EXTENSION pg_trgm;

To apply it to every schema, you can do the following:

create extension pg_trgm with schema pg_catalog;

If it still doesn't work

See if you running an experimental storage engine like OrioleDB. OrioleDB - as of March 2, 2025 - does not have support for GIN.

Last edited on