If you happen to come upon this error while using an ORM or you plain want to use hstore in postgresql
hstore isn’t enabled by default in postgresql and must be manually enabled for each database that will use it.
This will get you started with hstore in the ‘test’ database
Extensive hstore usage in every database might require a different approach.
Database created by default use template1 as their template. Putting hstore in the template1 template will allow all databases created from this point forward to have hstore enabled by default without further interaction.