You are not logged in.

Announcement

*** NOTICE: forum.openstreetmap.org is being retired. Please request a category for your community in the new ones as soon as possible using this process, which will allow you to propose your community moderators.
Please create new topics on the new site at community.openstreetmap.org. We expect the migration of data will take a few weeks, you can follow its progress here.***

#1 2012-11-27 11:20:53

errox
Member
Registered: 2012-11-26
Posts: 14

gist_geometry_ops doesnt exist for gist(Postgis 2.0.1 and Postgre 9.2)

Hello Everybody.

I Would like to Host my Own OpenStreetMap TileServer.

So i have to Create my Own Tiles.

I already Set Up my System:

Windows XP
PostGis 2.0.1
PostGre 9.2.

I Downloaded osm2pgsql and Geodata.

But if i try to Import the Geodata in die Database, it get me an error:

gist_geometry_ops doesnt exist for gist

Screenshot:

unbenannt2je.png

I have already imported the legacy.sql

Please Help Me!

Thank you!

Offline

#2 2012-11-27 15:25:47

JRA
Member
Registered: 2007-12-17
Posts: 677

Re: gist_geometry_ops doesnt exist for gist(Postgis 2.0.1 and Postgre 9.2)

Try to create the operator as advised here
http://trac.osgeo.org/postgis/ticket/1287
It is also possible that your PostGIS installation is fresh enough and includes  legacy_gist.sql  script and you can just run that.

Last edited by JRA (2012-11-27 15:26:10)

Offline

#3 2012-11-28 01:36:02

errox
Member
Registered: 2012-11-26
Posts: 14

Re: gist_geometry_ops doesnt exist for gist(Postgis 2.0.1 and Postgre 9.2)

legacy_gist.sql worked! Super! thank you so much!

Offline

Board footer

Powered by FluxBB