Hi there,
I’m having some trouble installing the pgRouting extension. Specifically, I want to add it to an existing database, but all the tutorials only seem to show creating a database with pgRouting, then loading data.
postgres=# SELECT postgis_full_version();
NOTICE: Function postgis_topology_scripts_installed() not found. Is topology support enabled and topology.sql installed?
postgis_full_version
----------------------------------------------------------------------------------------------------------------------------------------------------
POSTGIS="2.1.2 r12389" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.11.0, released 2014/04/16" LIBXML="2.9.1" RASTER
(1 row)
postgres=# select * from pgr_version();
version | tag | build | hash | branch | boost
---------+-----------------+-------+---------+--------+--------
2.0.0 | pgrouting-2.0.0 | 0 | f26831f | master | 1.55.0
(1 row)
postgres=# \c mydb
mydb=# create extension postgis;
ERROR: PostGIS is already installed in schema 'public', uninstall it first
alba3=# select * from pgr_version();
mydb: function pgr_version() does not exist
LINE 1: select * from pgr_version();
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
mydb=#
Can anyone point me in the right direction? Thanks!
…Rene