django.db.utils.ProgrammingError: type "hstore" does not exist

[Zhang Lei]

I'm using new database field 'HStoreField' in my project, my psycopg2 is 2.6 and postgresql is 9.4.11 with postgres.app. When I using python manage.py migrate, it raise a 'django.db.utils.ProgrammingError' which says django.db.utils.ProgrammingError: type "hstore" does not exist. I have added 'django.contrib.postgres' in my settings.INSTALLED_APPS. I have used ArrayField() with base_field 'CharField' is ok. Only when I using HStoreField, there is error.

[Tim Graham]

You need to create the hstore extension. I ran into this too and will submit a documentation patch.

[Zhang Lei]

Do you mind tell me how to use django.contrib.postgres.operations.HStoreExtension? I have create extension hstore manually in my psql command line. But I have encounter the same problem when I test my project.
Thank you very much.

[Zhang Lei]

Ok, I have figured this out. Create a empty migration file and use HStoreExtension. Thank you all the same. please close this ticket or other. Thank you.

[Claude Paroz]

Let's wait for the documentation complement before closing the bug.

[Tim Graham <timograham@…>]

In d3bf5e7b:

Fixed #24645 -- Documented use of HStoreExtension.

[Tim Graham <timograham@…>]

In 6e5e1a38:

[1.8.x] Fixed #24645 -- Documented use of HStoreExtension.

Backport of d3bf5e7b0016edc02e125699c0b0d3aa93404940 from master