Skip to content

Instantly share code, notes, and snippets.

@waterlink

waterlink/gist:5925542

Forked from terryjray/gist:3296171
Created July 4, 2013 07:09
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 waterlink/5925542 to your computer and use it in GitHub Desktop.
Save waterlink/5925542 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sh
RAILS_ENV=production rake db:setup
# produces the error below.....hmmm.....it's a no-worky
psql:/yourprojectpath/yourproject/db/structure.sql:29: ERROR: could not open extension control file "/usr/share/postgresql/9.1/extension/hstore.control": No such file or directory
# hstore postgresql extension needs to be installed, so....
sudo apt-get install postgresql-contrib
# now your extension should be available to enable so log in with psql
psql -d yourproject_production -U yourdbuser -W
# in the psql shell
CREATE EXTENSION hstore;
\q
# now you're golden, may need to clean up and re-run
RAILS_ENV=production rake db:drop
RAILS_ENV=production rake db:setup
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment