macos – PostgreSQL的问题

概述我正在尝试将pg_trgm模块加载到PostgreSQL,但出了点问题： $psql -d simko_development -f /usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sqlSETpsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:9: 我正在尝试将pg_trgm模块加载到Postgresql,但出了点问题：

$psql -d simko_development -f /usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sqlSETpsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:9: ERROR:  Could not access file "$libdir/pg_trgm": No such file or directorypsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:14: ERROR:  Could not access file "$libdir/pg_trgm": No such file or directorypsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:19: ERROR:  Could not access file "$libdir/pg_trgm": No such file or directorypsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:24: ERROR:  Could not access file "$libdir/pg_trgm": No such file or directorypsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:29: ERROR:  Could not access file "$libdir/pg_trgm": No such file or directorypsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:38: ERROR:  function similarity_op(text,text) does not existpsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:44: NOTICE:  type "gtrgm" is not yet definedDETAIL:  Creating a shell type deFinition.psql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:44: ERROR:  Could not access file "$libdir/pg_trgm": No such file or directorypsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:49: ERROR:  type gtrgm does not existpsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:55: ERROR:  function gtrgm_in(cstring) does not existpsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:61: ERROR:  Could not access file "$libdir/pg_trgm": No such file or directorypsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:66: ERROR:  Could not access file "$libdir/pg_trgm": No such file or directorypsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:71: ERROR:  Could not access file "$libdir/pg_trgm": No such file or directorypsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:76: ERROR:  Could not access file "$libdir/pg_trgm": No such file or directorypsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:81: ERROR:  Could not access file "$libdir/pg_trgm": No such file or directorypsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:86: ERROR:  Could not access file "$libdir/pg_trgm": No such file or directorypsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:91: ERROR:  type gtrgm does not existpsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:105: ERROR:  operator does not exist: text % textpsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:111: ERROR:  Could not access file "$libdir/pg_trgm": No such file or directorypsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:116: ERROR:  Could not access file "$libdir/pg_trgm": No such file or directorypsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:121: ERROR:  Could not access file "$libdir/pg_trgm": No such file or directorypsql:/usr/local/Cellar/postgresql/9.0.2/share/contrib/pg_trgm.sql:132: ERROR:  operator does not exist: text % text

> Mac OS X 10.6.6
> Postgresql 9.0.2(通过Homebrew确定)

更多信息：

$pg_config --sharedir/usr/local/Cellar/postgresql/9.0.2/share

解决方法 无法帮助您使用macos,但在debian-linux安装中经常出现相同的问题.解决方案非常简单：所需的库位于一个名为postgresql-contrib的独立包中,该包应另外安装到主postgresql包中. 总结

以上是内存溢出为你收集整理的macos – PostgreSQL的问题全部内容，希望文章能够帮你解决macos – PostgreSQL的问题所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。