Postgresql安装hstore
搭建rubygems.org 这个项目,执行迁移 # rake db:migrate RAILS_ENV=development 时候遇到一个错误
错误信息:
-- enable_extension("hstore")
rake aborted!
StandardError: An error has occurred,this and all later migrations canceled:
PG::UndefinedFile: 错误: 无法打开扩展控制文件 "/usr/share/pgsql/extension/hstore.control": 没有那个文件或目录
: CREATE EXTENSION IF NOT EXISTS "hstore"/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb:596:in `async_exec'
rake aborted!
StandardError: An error has occurred,this and all later migrations canceled:
PG::UndefinedFile: 错误: 无法打开扩展控制文件 "/usr/share/pgsql/extension/hstore.control": 没有那个文件或目录
: CREATE EXTENSION IF NOT EXISTS "hstore"/usr/local/rvm/gems/ruby-2.1.6/gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb:596:in `async_exec'
原因:要启用hstore扩展,但是我的环境中没有安装
解决方法:
命令:# yum installpostgresql-contrib-9.2.13-1.el7_1.x86_64
继续执行迁移任务 : #rake db:migrate RAILS_ENV=development
OK了,项目可以正常启动了
postgres=# create extension hstore; CREATE EXTENSION postgres=#