Ubuntu 12.04, PGSQL 9.3, PostGIS 2.1 and PL/R against libgdal1h from scratch
Removing preinstalled packages
First we need to check which PostgreSQL, PostGIS and GDAL versions are installed. To do so check your Debian package management system (dpkg).
dpkg -l | grep 'postgres\|gdal'You should get a list like the following one:
ii libgdal-dev 1.10.0-1~precise1 Geospatial Data Abstraction Library - Development files
ii libgdal1-dev 1.10.0-1~precise1 Geospatial Data Abstraction Library - Development files
ii libgdal1h 1.10.0-1~precise1 Geospatial Data Abstraction Library
ii postgresql-9.1 9.1.10-0ubuntu12.04 object-relational SQL database, version 9.1 server
ii postgresql-9.1-postgis-2.0 2.0.3-2~precise4 Geographic objects support for PostgreSQL 9.1
ii postgresql-9.1-postgis-2.0-scripts 2.0.3-2~precise4 Geographic objects support for PostgreSQL 9.1 -- scripts
ii postgresql-client-9.1 9.1.10-0ubuntu12.04 front-end programs for PostgreSQL 9.1
ii postgresql-client-common 129ubuntu1 manager for multiple PostgreSQL client versions
ii postgresql-common 129ubuntu1 PostgreSQL database-cluster manager
ii postgresql-contrib-9.1 9.1.10-0ubuntu12.04 additional facilities for PostgreSQLIf you want, you could remove these packages as follow:
apt-get purge libgdal-dev libgdal1-dev libgdal1h postgresql-9.1 postgresql-9.1-postgis-2.0 postgresql-9.1-postgis-2.0-scripts postgresql-client-9.1 postgresql-client-common postgresql-common
apt-get autoremove
apt-get autocleanInstalling PostgreSQL 9.3
First you need to find out your release code name:
lsb_release -cwhich get you something like that Codename: precise
Create a new file codename-pgdg.list in /etc/apt/sources.list.d according to the PostgreSQL wiki page.
vi /etc/apt/sources.list.d/precise-pgdg.listand add the following line
deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg mainNow we need to import the repository key from
wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -Now we can a update the repository and install the required packages from the PostgreSQL repository.
apt-get update
apt-get install postgresql-9.3 postgresql-contrib-9.3 postgresql-server-dev-9.3Compiling PostGIS 2.1 against libgdal >= 1.10.0
To install PostGIS 2.1 it is important that postgresql-server-dev-x.x is installed, because we need to compile PostGIS against these source files. We are going the install the precompiled libgdal 1.10.0 version from ubuntugis.
Install python-software-properties and add the apt sources (repositories):
apt-get install python-software-properties
add-apt-repository ppa:ubuntugis/ubuntugis-unstable
apt-get updateNow install the new GDAL library called libgdal1h and its’ development package
apt-get install libgdal1h
apt-cache showpkg libgdal-dev*which gets you something like that:
...
Provides:
1.10.0-1~precise1 -
1.9.0-3.1~pgdg12.4+1 -
...You can install a version using the -f flag
apt-get install -f libgdal-dev=1.10.0-1~precise1Before installing the PostGIS from source we install the required dependencies.
apt-get install make gcc checkinstall libxml2-dev libproj-dev libgeos-devDownload the latest PostGIS source and compile it
wget http://download.osgeo.org/postgis/source/postgis-2.1.0.tar.gz
tar xzvf postgis-2.1.0.tar.gz
cd postgis-2.1.0
./configure PostGIS is now configured for x86_64-unknown-linux-gnu
-------------- Compiler Info -------------
C compiler: gcc -g -O2
C++ compiler: g++ -g -O2
SQL preprocessor: /usr/bin/cpp -traditional-cpp -P
-------------- Dependencies --------------
GEOS config: /usr/bin/geos-config
GEOS version: 3.3.8
GDAL config: /usr/bin/gdal-config
GDAL version: 1.10.0
PostgreSQL config: /usr/bin/pg_config
PostgreSQL version: PostgreSQL 9.3.1
PROJ4 version: 48
Libxml2 config: /usr/bin/xml2-config
Libxml2 version: 2.8.0
JSON-C support: no
PostGIS debug level: 0
Perl: /usr/bin/perl
--------------- Extensions ---------------
PostGIS Raster: enabled
PostGIS Topology: enabled
SFCGAL support: disabled
-------- Documentation Generation --------
xsltproc:
xsl style sheets:
dblatex:
convert:
mathml2.dtd: http://www.w3.org/Math/DTD/mathml2/mathml2.dtduse checkinstall, which runs make install and registers the package in dpkg.
make
checkinstallR 3.0.2 and PL/R for PostgreSQL
Before we can install PL/R extension for PostgreSQL 9.3 we need to install R 3.0.2 as describe on the R-Project site. First edit the
vi /etc/apt/sources.listand add the following line and do a update
deb http://cran.r-project.org/bin/linux/ubuntu precise/as well as the key
apt-key adv --keyserver keyserver.ubuntu.com --recv-keys E084DAB9
apt-get updateThe search for the 3.0.2 R package version and install it.
apt-cache showpkg r-base
apt-get install -f r-base=3.0.2-1precise0Lastly we can install the PL/R extension for PostgreSQL from the PostgreSQL apt repository
apt-get install postgresql-9.3-plrSo … we are ready … have fun.