Skip to content

Instantly share code, notes, and snippets.

@tsavani
Created December 5, 2013 09:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tsavani/7802876 to your computer and use it in GitHub Desktop.
Save tsavani/7802876 to your computer and use it in GitHub Desktop.
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:
On Ubuntu, you need to install the extension by installing the postgresql-contrib package.
sudo apt-get install postgresql-contrib
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment