[GIS] Problem installing PostGIS on Ubuntu Server 13.10

postgispostgis-2.0postgresqlUbuntu

I've installed PostgreSQL 9.1 and postgis on Ubuntu Server 13.10 as follows:

sudo add-apt-repository-ppa:ubuntugis/ubuntugis-unstable
apt-get update
apt-get install postgresql-9.1-postgis

then I tried creating some special columns allowed by postgis like a geometry column but that doesn't exist. I did some search and found this https://stackoverflow.com/questions/8459361/postgis-install

so I tried:

CREATE EXTENSION postgis;
CREATE EXTENSION postgis_topology;

but I got this error: could not open extension control file "usr/share/postgresql"

Best Answer

I've used the following approach for installing postgis:

sudo apt-get install python-software-properties
sudo apt-add-repository ppa:ubuntugis/ppa
sudo apt-get update
sudo apt-get install postgresql-9.1
sudo apt-get install postgresql-9.1-postgis

Are you sure that it all installed without errors?

Related Question