Postgresq error: type 'hstore' does not exist

1 · Ariejan de Vroom · Aug. 5, 2015, midnight
Today I was programming and messed up my database schema in such a way that I just wanted to restore a recent backup and start over from there. dropdb app_development createdb app_development Unfortunately I ran into an error: PostgreSQL error: type ‘hstore’ does not exist hstore is a Postgresql extension (available since postgresql-9.x) that allows you store sets of key/value pairs within a single Postgresql value (read column)....