You don't need to do that, just 'CREATE EXTENSION postgis;' assuming you have a decently recent postgres and postgis
Cheers, Rémi-C 2014-03-28 12:26 GMT+01:00 Robert Burgholzer <[email protected]>: > 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): > > > > > createdb yourdatabase > > createlang plpgsql yourdatabase > > psql -d yourdatabase -f postgis.sql > > psql -d yourdatabase -f postgis_comments.sql > > psql -d yourdatabase -f spatial_ref_sys.sql > > On Friday, March 28, 2014, 3DCityModeler <[email protected]> wrote: > >> Hi there, >> >> To make a Raytracing Analysis of a 3DCity Area I will use the CityGML >> Format >> and therefore database format. I decided to choose PostgreSQL with PostGIS >> and 3DCityDB. >> >> But when creating a new database, after entering my password, the SRID and >> the SRSName the following error occurs: >> >> >> CREATE FUNCTION >> psql:CREATE_DB.sql:47: ERROR: *Relation ?spatial_ref_sys " is not >> existing* >> LINE 1: SELECT srid FROM spatial_ref_sys WHERE srid = $1 >> >> >> >> I am using Windows 7 system. >> >> Can somebody help me? >> >> Thanks >> >> >> >> -- >> View this message in context: >> http://postgis.17.x6.nabble.com/3DCityDB-Error-with-creation-of-database-tp5005987.html >> Sent from the PostGIS - User mailing list archive at Nabble.com. >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> > > > -- > -- > Robert W. Burgholzer > 'Making the simple complicated is commonplace; making the complicated > simple, awesomely simple, that's creativity.' - Charles Mingus > Athletics: http://athleticalgorithm.wordpress.com/ > Science: http://robertwb.wordpress.com/ > Wine: http://reesvineyard.wordpress.com/ > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
