Re: postgresql: Help with hstore hextension

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lu, Dan" <Dan(dot)Lu(at)sig(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "Kelly, Kevin" <Kevin(dot)Kelly(at)sig(dot)com>
Subject: Re: postgresql: Help with hstore hextension
Date: 2019-09-05 16:05:38
Message-ID: 27421.1567699538@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Lu, Dan" <Dan(dot)Lu(at)sig(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Moreno Andreo 2019-09-05 16:20:09 Re: Rebuild pg_toast from scratch?
Previous Message Lu, Dan 2019-09-05 15:04:57 postgresql: Help with hstore hextension