直接运行create extension pg_trgm;
报错
postgres=# create extension pg_trgm;
错误: 无法打开扩展控制文件 "/usr/pgsql-12/share/extension/pg_trgm.control": 没有那个文件或目录
解决步骤
*输入yum search contrib
postgresql10-contrib.x86_64 : Contributed source and binaries distributed with PostgreSQL postgresql11-contrib.x86_64 : Contributed source and binaries distributed with PostgreSQL postgresql12-contrib.x86_64 : Contributed source and binaries distributed with PostgreSQL postgresql94-contrib.x86_64 : Contributed source and binaries distributed with PostgreSQL postgresql95-contrib.x86_64 : Contributed source and binaries distributed with PostgreSQL postgresql96-contrib.x86_64 : Contributed source and binaries distributed with PostgreSQL
找到对应的数据库版本,我这边是12- 使用
r