8

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?

a_horse_with_no_name
  • 497,550
  • 91
  • 775
  • 843
user6731260
  • 95
  • 1
  • 4

1 Answers1

14

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
Community
  • 1
  • 1
Erwin Brandstetter
  • 539,169
  • 125
  • 977
  • 1,137