Skip to content

Instantly share code, notes, and snippets.

@Tab3r
Last active October 7, 2015 00:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save Tab3r/3076516 to your computer and use it in GitHub Desktop.
Save Tab3r/3076516 to your computer and use it in GitHub Desktop.
PostGIS 2.0.1 in Ubuntu 12.04
sudo apt-get install build-essential postgresql-9.1 postgresql-server-dev-9.1 libxml2-dev proj libjson0-dev xsltproc docbook-xsl docbook-mathml gettext postgresql-contrib-9.1 pgadmin3
sudo apt-add-repository ppa:olivier-berten/geo
sudo apt-get update
sudo apt-get install libgdal-dev
# Its looks like:
# $ gdal-config --version
# 1.9.0
# $ geos-config --version
# 3.3.4
sudo add-apt-repository ppa:webupd8team/java
sudo apt-get install oracle-java7-installer
# To remove error "GDALAllRegister"
sudo ln -s /usr/lib/jvm/java-7-oracle/jre/lib/amd64/server/libjvm.so /usr/lib/libjvm.so
sudo apt-get update
sudo apt-get upgrade
# is OK?
java -version
wget http://postgis.refractions.net/download/postgis-2.0.0.tar.gz
tar xfvz postgis-2.0.0.tar.gz
cd postgis-2.0.0
./configure --with-gui
make
sudo make install
sudo ldconfig
sudo make comments-install
sudo ln -sf /usr/share/postgresql-common/pg_wrapper /usr/local/bin/shp2pgsql
sudo ln -sf /usr/share/postgresql-common/pg_wrapper /usr/local/bin/pgsql2shp
sudo ln -sf /usr/share/postgresql-common/pg_wrapper /usr/local/bin/raster2pgsql
$ sudo -s -u postgres
postgres$ psql
psql (9.1.3)
Type "help" for help.
postgres=# \password postgres
Enter new password:
Enter it again:
postgres=# \q
postgres$
# ###########################################
# To enable spatial extensions in a datatable
# I give you 3 ways
# ###########################################
# 1) With Extensions in psql, in GIStest datatable
GIStest=# CREATE EXTENSION postgis;
CREATE EXTENSION
GIStest=#
GIStest=# CREATE EXTENSION postgis_topology;
CREATE EXTENSION
GIStest=#
# 2) In PgAdmin3:
# Use Extension -> Add -> postgis
# Extension -> Add -> postgis_topology
#
# 3) Create a template
sudo -u postgres createdb template_postgis
sudo -u postgres psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.0.1/postgis.sql
sudo -u postgres psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.0.1/spatial_ref_sys.sql
sudo -u postgres psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.0.1/postgis_comments.sql
sudo -u postgres psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.0.1/rtpostgis.sql
sudo -u postgres psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.0.1/raster_comments.sql
sudo -u postgres psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.0.1/topology.sql
sudo -u postgres psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.0.1/topology_comments.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment