-
-
Save djq/2846196 to your computer and use it in GitHub Desktop.
Install Postgres 9.1, PostGIS 2.0.2 and PG Routing on Ubuntu 12.04 (Precise Pangolin)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
# | |
# Install Postgres 9.1, PostGIS 2.0 and pgRouting on a clean Ubuntu 12.04 install (64 bit) | |
# updated to PostGIS 2.0.1 | |
# basics | |
apt-get install python-software-properties | |
apt-add-repository ppa:sharpie/for-science # To get GEOS 3.3.3 | |
# install the following pacakages | |
apt-get -y install postgresql-9.1 postgresql-server-dev-9.1 postgresql-contrib-9.1 gdal-bin binutils libgeos-c1 libgeos-dev libgdal1-dev libxml2 libxml2-dev libxml2-dev checkinstall libproj-dev libpq-dev build-essential | |
# some missing packages for some reason | |
apt-get update --fix-missing | |
# run again | |
apt-get -y install postgresql-9.1 postgresql-server-dev-9.1 postgresql-contrib-9.1 gdal-bin binutils libgeos-c1 libgeos-dev libgdal1-dev libxml2 libxml2-dev libxml2-dev checkinstall libproj-dev libpq-dev build-essential | |
# fetch, compile and install PostGIS | |
wget http://postgis.refractions.net/download/postgis-2.0.2.tar.gz | |
tar zxvf postgis-2.0.2.tar.gz && cd postgis-2.0.2 | |
./configure --with-raster --with-topology | |
make | |
make install | |
## pgrouting - Add pgRouting launchpad repository | |
sudo add-apt-repository ppa:georepublic/pgrouting | |
sudo apt-get update | |
# Install pgRouting packages | |
sudo apt-get install gaul-devel \ | |
postgresql-9.1-pgrouting \ | |
postgresql-9.1-pgrouting-dd \ | |
postgresql-9.1-pgrouting-tsp | |
# Install osm2pgrouting package | |
sudo apt-get install osm2pgrouting | |
# Install workshop material (optional) | |
sudo apt-get install pgrouting-workshop | |
# create a table called 'routing' | |
sudo su postgres | |
createdb routing | |
# add PostGIS functions (version 2.x) to 'routing' | |
psql -d routing -c "CREATE EXTENSION postgis;" | |
# add pgRouting core functions to 'routing' | |
psql -d routing -f /usr/share/postlbs/routing_core.sql | |
psql -d routing -f /usr/share/postlbs/routing_core_wrappers.sql | |
psql -d routing -f /usr/share/postlbs/routing_topology.sql |
I think running apt-get update
after adding the for-science
PPA will fix the need to run install twice.
hi :)
first of all, great tutorial!
but small problem has appeared...
everything works fine except the very last step. when I try to add pgRouting core functions to 'routing', it doesn't find the files.
for example:
when I add:
psql -d routing -f /usr/share/postlbs/routing_core.sql
I get:
/usr/share/postlbs/routing_core.sql: No such file or directory
the directory already exists, but those 3 files not. I've tried to google the problem, but i couldn't find any solution that would work for me.
Have you got any idea how to solve this problem?
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
no it's not down but there are no builds for Ubuntu 13: pgRouting/pgrouting#152