Changes between Initial Version and Version 1 of UsersWikiPostGIS21Ubuntu1404src

Timestamp:

Jul 28, 2014, 4:01:42 AM (10 years ago)

Author:

Mike Taves

Comment:

create instructions for PostGIS 2.1 on Ubuntu 14.04 LTS (trusty)

UsersWikiPostGIS21Ubuntu1404src

@@ +1 @@
+= How to install PostGIS 2.1 on Ubuntu 14.04 LTS (''trusty'') from source =
+
+== Prerequisites ==
+Several components are needed, which can either be built from source or installed from pre-built packages, as shown below.
+
+Install prerequisite packages using:
+{{{
+sudo apt-get install build-essential postgresql-9.3 postgresql-server-dev-9.3 libgeos-c1 libgdal-dev libproj-dev libjson-c-dev libxml2-dev libxml2-utils xsltproc docbook-xsl docbook-mathml
+}}}
+
+== Build PostGIS ==
+{{{
+wget http://download.osgeo.org/postgis/source/postgis-2.1.3.tar.gz
+tar xfz postgis-2.1.3.tar.gz
+cd postgis-2.1.3
+}}}
+
+A basic configuration for PostGIS 2.1, with raster and topology support:
+{{{
+./configure
+make
+sudo make install
+sudo ldconfig
+sudo make comments-install
+}}}
+
+Lastly, enable the command-line tools to work from your shell:
+{{{
+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
+}}}
+
+== Spatially enabling a database ==
+
+Connect to your database using pgAdminIII or psql, and use the commands to add the PostgreSQL extensions. To add PostGIS with raster support:
+{{{
+CREATE EXTENSION postgis;
+}}}
+
+To add topology support, a second extension can be created on the database:
+{{{
+CREATE EXTENSION postgis_topology;
+}}}
+
+== See also ==
+ * https://help.ubuntu.com/community/PostgreSQL