Re: postgresql: Help with hstore hextension - Mailing list pgsql-general

From Tom Lane
Subject Re: postgresql: Help with hstore hextension
Date
Msg-id 27421.1567699538@sss.pgh.pa.us
Whole thread Raw
In response to postgresql: Help with hstore hextension  ("Lu, Dan" <Dan.Lu@sig.com>)
Responses RE: postgresql: Help with hstore hextension
List pgsql-general
"Lu, Dan" <Dan.Lu@sig.com> 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



pgsql-general by date:

Previous
From: "Lu, Dan"
Date:
Subject: postgresql: Help with hstore hextension
Next
From: Moreno Andreo
Date:
Subject: Re: Rebuild pg_toast from scratch?