Missing hstore extension

Question

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 1

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

• Error when creating unaccent extension on PostgreSQL