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?

Which operating system are you using? How did you install Postgres? On most Linux systems you need to install the -contrib package manually. — a_horse_with_no_name, Aug 29 '16 at 11:25

score 14 · Answer 1 · edited May 23 '17 at 10:31

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

edited May 23 '17 at 10:31

Community

answered Aug 29 '16 at 11:26

2

use postgresql11-contrib if you want to install for postgres11 – brainLoop Mar 04 '19 at 05:12

1 Answers1