Skip to content

Instantly share code, notes, and snippets.

@tsavani
tsavani / gist:7802876
Created December 5, 2013 09:59
Error : No such file found hstore.control in postgresql database
I have setup a new database for installing Discourse in PostgreSQL. When I run rake db:migrate, it creates most of the tables, but it then fails:
execute("CREATE EXTENSION IF NOT EXISTS hstore")
rake aborted!
An error has occurred, this and all later migrations canceled:
PG::Error: ERROR: could not open extension control file "/usr/share/postgresql/9.1/extension/hstore.control": No such file or directory
: CREATE EXTENSION IF NOT EXISTS hstore
Soln: