Ubuntu – Postgres doesn’t have hstore extension

postgresql

I was trying to run the following command but i threw me any error.

template1=# CREATE EXTENSION hstore

ERROR: could not open extension control file "usr/share/postgreesql/9.2/extension/hstore.control": No such file or directory

It seems like I need to download the postgres-devel packages, but I don't know exactly what I am missing. I installed my postgres with this command so I thought everything I need would be included together.

sudo apt-get install postgres-9.2

Any help will be appreciated. Thank you.

Best Answer

The hstore extension, as well as many other extensions such as cube, fuzzystrmatch, uuid-ossp, etc., are packaged in postgresql-contrib, which you can install for your PostgreSQL version using:

sudo apt-get install postgresql-contrib-9.2

On a standard Ubuntu install,

sudo apt-get install postgresql postgresql-contrib

will install PostgreSQL with its contributed extensions.

Related Solutions

Ubuntu – rails & libpq-dev nasty dependencies

The real solution is, as correctly pointed out by Amit Patel, to install libpq-dev

Here is a workaround if you were unable to setup pg at you development machine. You can use sqlite in your local machine and pg in Heroku. Here is what you should have in your Gemfile

group :production do
  gem 'pg'
end

group :development, :test do
  gem 'sqlite3'
end

And use this command for installing bundle to ignore production gems:

bundle install --without production

Please keep in mind that not having same environment in production and development machines is not recommended.

Ubuntu – ubuntu machine had postgresql folder blown away manually – can’t install or remove any packages

Have you tried to just purge the packages left from the failed removal attempt manually?

sudo apt-get purge postgresql-client-9.4 postgresql-client-common postgresql-common

Then:

sudo apt-get update install postgresql

The removal obviously fails because postgresql is not installed, but the reinstallation might be failing because something is wrong with what has been left from the previous installation.

Best Answer

Related Solutions

Ubuntu – rails & libpq-dev nasty dependencies

Ubuntu – ubuntu machine had postgresql folder blown away manually – can’t install or remove any packages

Related Question