how to change install postgis location? postgres

database postgresql ubuntu postgis
Tsuna picture Tsuna · Jan 15, 2017 · Viewed 11.4k times · Source

When I am in my postgres db and tried to create an extension for my db, I get this error

ERROR: could not open extension control file "/usr/share/postgresql/9.5/extension/postgis.control": No such file or directory

I know there are so many posts out there with this error and solutions and I tried them all too. Found so much in stackoverflow but none of them worked.

I realized in my postgresql directory there are 9.2, 9.3, 9.4, 9.5, 9.6,

I went into the directory in the error and I realized there is really no postgis.control inside 9.5

I checked my psql version and showed 9.6.1

I went into 9.6 folder and I DO see a postgis.control in it.

I want to changed the installation directory so when i run

create extension postgis

it would go

"/usr/share/postgresql/9.6/extension/postgis.control"

instead of

"/usr/share/postgresql/9.5/extension/postgis.control"

Can someone please give me a hand?

Thanks in advance.

P.S. Using Ubuntu 14.04 and also have Ubuntu 16.04 as desktop which I haven't try to install postgis yet

Answer

Venkatesh Lokare picture Venkatesh Lokare · Mar 16, 2017

You should use the following command:

sudo apt-get install postgresql-9.6-postgis-scripts

Related questions

postgresql autovacuum not working although process is running

I have PostgreSQL 9.2 running on Ubuntu. The autovacuum process is running on the server. The database has heavy load, 1000's of additions and 100's of deletions daily and yet it seems that autovacuum isn't firing up. There is nothing relating …

Read More
How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More
What is this Javascript "require"?

I'm trying to get Javascript to read/write to a PostgreSQL database. I found this project on github. I was able to get the following sample code to run in node. var pg = require('pg'); //native libpq bindings = `var pg = …

Read More