Missing hstore extension

postgresql hstore
user6731260 picture user6731260 · Aug 29, 2016 · Viewed 7.6k times · Source

I am running postgresql-9.5.3 and I tried to create extension:

CREATE EXTENSION IF NOT EXISTS hstore;

but I got this error:

could not open extension control file "/usr/share/pgsql/extension/hstore.control": No such file or directory

How can I install hstore?

Answer

Erwin Brandstetter picture Erwin Brandstetter · Aug 29, 2016

The package providing additional modules must be installed in your system.

For Fedora:

yum install postgresql-contrib

Or (for plain users):

sudo yum install postgresql-contrib

Related questions

How to create a new database with the hstore extension already installed?

Recently I went into trouble trying to use hstore with Django. I installed hstore this way: $ sudo -u postgres psql postgres=# CREATE EXTENSION hstore; WARNING: => is deprecated as an operator name DETAIL: This name may be disallowed altogether in …

Read More
How to query values with wildcards in PostgreSQL hstore

I'm trying to query hstore for all the values of a certain key that match a search criteria. I can get all the values for a certain key like this: SELECT DISTINCT svals(slice(data, ARRAY['Supplier'])) FROM "products" I …

Read More
Why can only a superuser CREATE EXTENSION hstore, but not on Heroku?

When I attempt to enable hstore on my database: => CREATE EXTENSION IF NOT EXISTS hstore; ERROR: permission denied to create extension "hstore" HINT: Must be superuser to create this extension. My user is not a superuser, but is the …

Read More