Monday, 8 September 2014

CREATE EXTENSION hstore getting error

Log:
-------------------------------------------------------------------------------------------------------------------
-- execute("CREATE EXTENSION hstore")
rake aborted!

StandardError: An error has occurred, this and all later migrations canceled:

PG::UndefinedFile: ERROR:  could not open extension control file "/usr/share/postgresql/9.1/extension/hstore.control": No such file or directory
: CREATE EXTENSION hstore/usr/local/rvm/gems/[email protected]/gems/activerecord-4.1.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `async_exec'
--------------------------------------------------------------------------------------------------------------------

Solution:

If you have postgresql already installed then run below command

$ sudo apt-get install postgresql-contrib


No comments:

Post a comment