<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">So, I already had postgis extension installed in the postgres database. <div><br></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><div>postgres=# SELECT postgis_full_version();</div><div>NOTICE: Function postgis_topology_scripts_installed() not found. Is topology support enabled and topology.sql installed?</div><div> postgis_full_version </div><div>----------------------------------------------------------------------------------------------------------------------------------------------------</div><div> 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</div><div>(1 row)</div></blockquote><div><br></div><div>Plus, I installed pgrouting:</div><div><br></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><div>postgres=# create extension postgis from unpackaged;</div><div>ERROR: extension "postgis" already exists</div><div>postgres=# select * from pgr_version();</div><div> version | tag | build | hash | branch | boost </div><div>---------+-----------------+-------+---------+--------+--------</div><div> 2.0.0 | pgrouting-2.0.0 | 0 | f26831f | master | 1.55.0</div><div>(1 row)</div></blockquote><div><br></div><div>The problem seems to be, that when I change to mydb, postgis is available, but pgrouting is not—and when I try to create the extension in mydb, pgrouting complains that postgis is not there… but it is clearly accessible.</div><div><br></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><div>postgres=# \c mydb</div><div>You are now connected to database "mydb" as user "postgres".</div><div>mydb=# SELECT postgis_full_version();</div><div>NOTICE: Function postgis_gdal_version() not found. Is raster support enabled and rtpostgis.sql installed?</div><div>NOTICE: Function postgis_topology_scripts_installed() not found. Is topology support enabled and topology.sql installed?</div><div>NOTICE: Function postgis_raster_scripts_installed() not found. Is raster support enabled and rtpostgis.sql installed?</div><div>NOTICE: Function postgis_raster_lib_version() not found. Is raster support enabled and rtpostgis.sql installed?</div><div> postgis_full_version </div><div>---------------------------------------------------------------------------------------------------------------------------------------------------</div><div> POSTGIS="2.1.2 r12389" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" LIBXML="2.9.1" (core procs from "2.1.1 r12113" need upgrade)</div><div>(1 row)</div><div><br></div><div>mydb=# select * from pgr_version();</div><div>ERROR: function pgr_version() does not exist</div><div>LINE 1: select * from pgr_version();</div><div> ^</div><div>HINT: No function matches the given name and argument types. You might need to add explicit type casts.</div><div>mydb=# create extension postgis from unpackaged;</div><div>ERROR: type "raster" does not exist</div><div>mydb=# </div></blockquote><div><br></div><div>Now, I’m pretty sure the problems I’m having are simply the result of not understanding how/where extensions are created and accessible by individual databases. (So, sorry for the silly questions.)</div><div><br></div><div>…Rene</div><div><div><br><div><div>On Jul 15, 2014, at 6:46 PM, Stephen Woodbridge <<a href="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">On 7/15/2014 8:31 PM, René Fournier wrote:<br><blockquote type="cite">Hi there,<br><br>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.<br><br>postgres=# SELECT postgis_full_version();<br>NOTICE: Function postgis_topology_scripts_installed() not found. Is topology support enabled and topology.sql installed?<br> postgis_full_version<br>----------------------------------------------------------------------------------------------------------------------------------------------------<br>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<br>(1 row)<br><br>postgres=# select * from pgr_version();<br>version | tag | build | hash | branch | boost<br>---------+-----------------+-------+---------+--------+--------<br>2.0.0 | pgrouting-2.0.0 | 0 | f26831f | master | 1.55.0<br>(1 row)<br><br>postgres=# \c mydb<br><br>mydb=# create extension postgis;<br>ERROR: PostGIS is already installed in schema 'public', uninstall it first<br></blockquote><br>This is ok and can be ignored.<br><br><blockquote type="cite">alba3=# select * from pgr_version();<br>mydb: function pgr_version() does not exist<br>LINE 1: select * from pgr_version();<br> ^<br>HINT: No function matches the given name and argument types. You might need to add explicit type casts.<br></blockquote><br>This fails correctly because you have not installed pgrouting!<br><br>create extension pgrouting;<br>select * from pgr_version();<br><br>It is possible that the pgrouting extension is dependent on have postgis installed as an extension rather then from the sql script. You can fix this with:<br><br>create extension postgis from unpackaged;<br><br>Then run the commands above.<br><br>-Steve<br><br><blockquote type="cite">mydb=#<br><br><br>Can anyone point me in the right direction? Thanks!<br><br>…Rene<br>_______________________________________________<br>Pgrouting-users mailing list<br><a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>http://lists.osgeo.org/mailman/listinfo/pgrouting-users<br><br></blockquote><br>_______________________________________________<br>Pgrouting-users mailing list<br><a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>http://lists.osgeo.org/mailman/listinfo/pgrouting-users<br></blockquote></div><br></div></div></body></html>