"Lu, Dan" <Dan.Lu@xxxxxxx> writes: > We are now trying to create "hstore" extension and ran into the error below. > opm=# CREATE EXTENSION hstore; > ERROR: could not open extension control file "/pgdbadevbal801/pg/PostgreSQL-10.7/share/postgresql/extension/hstore.control": No such file or directory You need to build/install the contrib/hstore module, or possibly you'd just want to install all of contrib. "make all" and "make install" at the top level don't touch the contrib subtree. If you already wiped your build tree, you'll have to recreate it --- be careful to give the same configure arguments as you used before. regards, tom lane
