How to install pgRouting on PostgreSQL 9.2 located at /opt/PostgreSQL/9.2/ on Ubuntu Server 12.10?

Question

I have installed PostgreSQL 9.2 on Ubuntu Server 12.10 using one-click installer from the EnterpriseDB. Then using the StackBuilder I installed PostGIS.

Now I also want to install the pgRouting extension to my database. So far I have found instructions on the following pages:

• http://pgrouting.org/download.html
• http://docs.pgrouting.org/2.0/en/doc/src/installation/index.html#ubuntu-debian

• http://workshop.pgrouting.org/chapters/installation.html#pgrouting

  sudo add-apt-repository ppa:georepublic/pgrouting-unstable
  sudo apt-get update
  sudo apt-get install postgresql-9.1-pgrouting
  

But the last command try to install postgresql-9.1 from the apt repositories:

# sudo apt-get install postgresql-9.1-pgrouting
Reading package lists... Done
Building dependency tree 
Reading state information... Done
The following extra packages will be installed:
 libboost-thread1.49.0 libcgal9 libgeos-3.3.3 libgeos-c1 libproj0 libqt4-dbus libqt4-declarative libqt4-designer
 libqt4-help libqt4-network libqt4-opengl libqt4-script libqt4-scripttools libqt4-sql libqt4-sql-mysql
 libqt4-sql-sqlite libqt4-svg libqt4-test libqt4-xml libqt4-xmlpatterns libqtcore4 libqtgui4 postgis
 postgresql-9.1 postgresql-9.1-postgis postgresql-common proj-data qdbus
Suggested packages:
 proj-bin libqt4-declarative-folderlistmodel libqt4-declarative-gestures libqt4-declarative-particles
 libqt4-declarative-shaders qt4-qmlviewer libqt4-dev qt4-qtconfig oidentd ident-server locales-all osm2pgrouting
 pgrouting-workshop
The following NEW packages will be installed:
 libboost-thread1.49.0 libcgal9 libgeos-3.3.3 libgeos-c1 libproj0 libqt4-opengl postgis postgresql-9.1
 postgresql-9.1-pgrouting postgresql-9.1-postgis postgresql-common proj-data
The following packages will be upgraded:
 libqt4-dbus libqt4-declarative libqt4-designer libqt4-help libqt4-network libqt4-script libqt4-scripttools
 libqt4-sql libqt4-sql-mysql libqt4-sql-sqlite libqt4-svg libqt4-test libqt4-xml libqt4-xmlpatterns libqtcore4
 libqtgui4 qdbus

I want to install pgRouting on my existing PostgreSQL which is located at:

/opt/PostgreSQL/9.2/

I have also downloaded the source code. Following these instructions:

mkdir build
cd build
cmake -DWITH_DD=ON ..
make
sudo make install

When I run

# cmake -DWITH_DD=ON ..
-- PGROUTING_GIT_TAG: pgrouting-2.0.0
-- PGROUTING_GIT_BUILD: 0
-- PGROUTING_GIT_HASH: f26831f
-- PGROUTING_GIT_BRANCH: master
-- PGROUTING_VERSION_REVISION_NAME: f26831f master
-- PGROUTING_VERSION_REVISION_HASH: f26831f
-- UNIX=1
-- WIN32=
-- POSTGRESQL_EXECUTABLE is POSTGRESQL_EXECUTABLE-NOTFOUND
-- POSTGRESQL_PG_CONFIG is POSTGRESQL_PG_CONFIG-NOTFOUND
-- PostgreSQL not found.
CMake Error at CMakeLists.txt:122 (message):
 Please check your PostgreSQL installation.
-- Configuring incomplete, errors occurred!

I can't figure out a way to tell cmake to locate my existing PostgreSQL installation.

Any suggestions are very welcome.

• Craig Ringer: Set PATH=/opt/PostgreSQL/9.2/bin:$PATH then re-try. Failing that I expect you'll need to read the manual to tell it how to find pg_config, or read the CMakefile. The manual looks kind of sparse.'
• Craig Ringer: Done as suggested. Glad to help.

Answer 1

You can't install pgrouting for PostgreSQL 9.1 into PostgreSQL 9.2. Even if you could install the package without downloading all of 9.1, it wouldn't work, it'd just be unavailable - totally invisible to Pg 9.2.

If PgRouting is not included in EDB's StackBuilder you will need to build it from source code according to the instructions on the PgRouting website. See the source code readme for guidance on this process. When compiling pgrouting, you may need to add the appropriate pg_config to the PATH, e.g:

PATH=/opt/PostgreSQL/9.2/bin:$PATH

Alternately, you could use the PGDG packages of PostgreSQL for Ubuntu instead of the EDB installer. That will get you PostGIS and PgRouting for PostgreSQL 9.2 (or 9.3) via apt-get. See http://wiki.postgresql.org/wiki/Apt . This will do a new PostgreSQL installation - it won't use your existing database in /opt, so you will need to do a pg_dump and then restore the DB if there's any data you want to keep. It won't delete or replace the DB in /opt, it'll just create a new PostgreSQL on a different port, probably 5433.

• nilgun: Thank you very much for your detailed answer. I have updated my question to show the cmake error when compiling the source code. I really want to use my existing database because I have web applications in production running on it.