9

I am running PostgreSQL 9.5.3 Fedora Linux, and I tried to create the "hstore" 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?

Erwin Brandstetter
  • 605,456
  • 145
  • 1,078
  • 1,228
user6731260
  • 105
  • 1
  • 1
  • 4
  • Which operating system are you using? How did you install Postgres? On most Linux systems you need to install the -contrib package manually. –  Aug 29 '16 at 11:25
  • I am on fedora,how can I check if it is installed? – user6731260 Aug 29 '16 at 11:26

1 Answers1

15

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

For Fedora (as privileged system user):

yum install postgresql-contrib

Or (for plain users):

sudo yum install postgresql-contrib

For Debian & friends, see:

Erwin Brandstetter
  • 605,456
  • 145
  • 1,078
  • 1,228