<div dir="ltr"><div>You don't need to do that,<br>just <br>'CREATE EXTENSION postgis;'<br><br></div><div>assuming you have a decently recent postgres and postgis<br></div><div><br></div>Cheers,<br>Rémi-C<br></div>
<div class="gmail_extra"><br><br><div class="gmail_quote">2014-03-28 12:26 GMT+01:00 Robert Burgholzer <span dir="ltr"><<a href="mailto:rburghol@vt.edu" target="_blank">rburghol@vt.edu</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Loojs like postGIS did not get installed. Two tables are created and populated as part of the intall process "geometry_columns" and "spatial_ref_sys" - part of install requires executing sql scripts inckuded in the install process (this is *nix but the same should apply in win):<div>
<br></div><div> <br><pre style="border-width:2px 0px;border-color:rgb(247,147,30);border-style:solid;margin-bottom:10px;margin-top:10px;overflow:auto;padding:10px;border-top-left-radius:2px;border-top-right-radius:2px;border-bottom-right-radius:2px;border-bottom-left-radius:2px">
<font face="Helvetica Neue, Helvetica, Arial, sans-serif" size="3"><span style="white-space:normal;background-color:rgba(255,255,255,0)">
createdb yourdatabase </span></font></pre><pre style="border-width:2px 0px;border-color:rgb(247,147,30);border-style:solid;margin-bottom:10px;margin-top:10px;overflow:auto;padding:10px;border-top-left-radius:2px;border-top-right-radius:2px;border-bottom-right-radius:2px;border-bottom-left-radius:2px">
<font face="Helvetica Neue, Helvetica, Arial, sans-serif" size="3"><span style="white-space:normal;background-color:rgba(255,255,255,0)">createlang plpgsql yourdatabase </span></font></pre><pre style="border-width:2px 0px;border-color:rgb(247,147,30);border-style:solid;margin-bottom:10px;margin-top:10px;overflow:auto;padding:10px;border-top-left-radius:2px;border-top-right-radius:2px;border-bottom-right-radius:2px;border-bottom-left-radius:2px">
<font face="Helvetica Neue, Helvetica, Arial, sans-serif" size="3"><span style="white-space:normal;background-color:rgba(255,255,255,0)">psql -d yourdatabase -f postgis.sql </span></font></pre><pre style="border-width:2px 0px;border-color:rgb(247,147,30);border-style:solid;margin-bottom:10px;margin-top:10px;overflow:auto;padding:10px;border-top-left-radius:2px;border-top-right-radius:2px;border-bottom-right-radius:2px;border-bottom-left-radius:2px">
<font face="Helvetica Neue, Helvetica, Arial, sans-serif" size="3"><span style="white-space:normal;background-color:rgba(255,255,255,0)">psql -d yourdatabase -f postgis_comments.sql </span></font></pre><pre style="border-width:2px 0px;border-color:rgb(247,147,30);border-style:solid;margin-bottom:10px;margin-top:10px;overflow:auto;padding:10px;border-top-left-radius:2px;border-top-right-radius:2px;border-bottom-right-radius:2px;border-bottom-left-radius:2px">
<font face="Helvetica Neue, Helvetica, Arial, sans-serif" size="3"><span style="white-space:normal;background-color:rgba(255,255,255,0)"><span></span>psql -d yourdatabase -f spatial_ref_sys.sql</span></font></pre><div><div class="h5">
On Friday, March 28, 2014, 3DCityModeler <<a href="mailto:jo_be@gmx.net" target="_blank">jo_be@gmx.net</a>> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi there,<br>
<br>
To make a Raytracing Analysis of a 3DCity Area I will use the CityGML Format<br>
and therefore database format. I decided to choose PostgreSQL with PostGIS<br>
and 3DCityDB.<br>
<br>
But when creating a new database, after entering my password, the SRID and<br>
the SRSName the following error occurs:<br>
<br>
<br>
CREATE FUNCTION<br>
psql:CREATE_DB.sql:47: ERROR: *Relation ?spatial_ref_sys " is not existing*<br>
LINE 1: SELECT srid FROM spatial_ref_sys WHERE srid = $1<br>
<br>
<br>
<br>
I am using Windows 7 system.<br>
<br>
Can somebody help me?<br>
<br>
Thanks<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://postgis.17.x6.nabble.com/3DCityDB-Error-with-creation-of-database-tp5005987.html" target="_blank">http://postgis.17.x6.nabble.com/3DCityDB-Error-with-creation-of-database-tp5005987.html</a><br>
Sent from the PostGIS - User mailing list archive at Nabble.com.<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a>postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</blockquote></div></div></div><span class="HOEnZb"><font color="#888888"><br><br>-- <br><div dir="ltr">--<br>Robert W. Burgholzer<br> 'Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity.' - Charles Mingus<div>
Athletics: <a href="http://athleticalgorithm.wordpress.com/" target="_blank">http://athleticalgorithm.wordpress.com/</a> <br></div><div>Science: <a href="http://robertwb.wordpress.com/" target="_blank">http://robertwb.wordpress.com/</a></div>
<div>Wine: <a href="http://reesvineyard.wordpress.com/" target="_blank">http://reesvineyard.wordpress.com/</a></div></div><br>
</font></span><br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>