Habe fast das gleiche Problem:
System:
Distributor ID: Ubuntu
Description: Ubuntu 12.04.3 LTS
Release: 12.04
Codename: precise
Prozessor:
4 x
[...]
vendor_id : GenuineIntel
cpu family : 6
model : 42
model name : Intel(R) Core(TM) i5-2500 CPU @ 3.30GHz
stepping : 7
microcode : 0x14
cpu MHz : 1600.000
cache size : 6144 KB
[...]
PostgreSQL:
Package: postgresql
Status: install ok installed
Priority: optional
Section: database
Installed-Size: 63
Maintainer: Martin Pitt <martin.pitt@ubuntu.com>
Architecture: all
Source: postgresql-common (129ubuntu1)
Version: 9.1+129ubuntu1
Depends: postgresql-9.1
Postgis:
SELECT post_full_version();
"POSTGIS="2.0.1 r9979" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8" RASTER"
---
$ dpkg -s postgis
Package: postgis
Status: install ok installed
Priority: optional
Section: misc
Installed-Size: 2917
Maintainer: Debian GIS Project <pkg-grass-devel@lists.alioth.debian.org>
Architecture: amd64
Version: 2.0.1-2~precise3
Depends: libc6 (>= 2.14), libgdal1 (>= 1.9.0), libgeos-c1 (>= 3.3.3), libglib2.0-0 (>= 2.12.0), libgtk2.0-0 (>= 2.14.0), libpq5, postgresql-9.1-postgis
Hier der osm2pgsql Befehl
Karten$ osm2pgsql -c -d OSM_Oberrhein -U postgres -H localhost -S ./default.style ./Oberrhein.osm
osm2pgsql SVN version 0.70.5
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE: table "planet_osm_point" does not exist, skipping
NOTICE: table "planet_osm_point_tmp" does not exist, skipping
Setting up table: planet_osm_line
NOTICE: table "planet_osm_line" does not exist, skipping
NOTICE: table "planet_osm_line_tmp" does not exist, skipping
Setting up table: planet_osm_polygon
NOTICE: table "planet_osm_polygon" does not exist, skipping
NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping
Setting up table: planet_osm_roads
NOTICE: table "planet_osm_roads" does not exist, skipping
NOTICE: table "planet_osm_roads_tmp" does not exist, skipping
Mid: Ram, scale=100
Reading in file: ./Oberrhein.osm
Processing: Node(28822k) Way(4530k) Relation(46570) parse time: 2138s
Node stats: total(28822374), max(2147483645)
Way stats: total(4530516), max(238065157)
Relation stats: total(46570), max(3208127)
Writing way (4530k)
Writing relation (46457)
Committing transaction for planet_osm_roads
Committing transaction for planet_osm_point
Sorting data and creating indexes for planet_osm_roads
Sorting data and creating indexes for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Sorting data and creating indexes for planet_osm_line
Sorting data and creating indexes for planet_osm_polygon
CREATE INDEX planet_osm_roads_index ON planet_osm_roads USING GIST (way GIST_GEOMETRY_OPS) TABLESPACE pg_default;
failed: ERROR: operator class "gist_geometry_ops" does not exist for access method "gist"
Error occurred, cleaning up
Speicherzugriffsfehler (Speicherabzug geschrieben)
Jedoch ist die Datenbank in die die Daten geladen werden noch leer, hat also keine Tabellen außer spatial_ref_sys, welche durch Create Extension postgis; erzeugt wurde. Demzufolge wüsste ich gerade nicht, wie ich http://www.postgis.org/docs/PostGIS_FAQ.html#legacy_faq_gist anwenden soll.
legacy.sql wurde bereits ausgeführt, legacy_gist.sql gibts nicht
Hier der Inhalt des Postgisverzeichnisses:
/usr/share/postgresql/9.1/contrib/postgis-2.0$ ls -l
insgesamt 5228
-rw-r--r-- 1 root root 2055 Dez 6 2012 legacy_minimal.sql
-rw-r--r-- 1 root root 53961 Dez 6 2012 legacy.sql
-rw-r--r-- 1 root root 64270 Dez 6 2012 postgis_comments.sql
-rwxr-xr-x 1 root root 146156 Dez 6 2012 postgis_restore.pl
-rw-r--r-- 1 root root 194675 Dez 6 2012 postgis.sql
-rw-r--r-- 1 root root 149790 Dez 6 2012 postgis_upgrade_20_minor.sql
-rw-r--r-- 1 root root 68850 Dez 6 2012 raster_comments.sql
-rw-r--r-- 1 root root 5195 Dez 6 2012 rtpostgis_legacy.sql
-rw-r--r-- 1 root root 183197 Dez 6 2012 rtpostgis.sql
-rw-r--r-- 1 root root 199364 Dez 6 2012 rtpostgis_upgrade_20_minor.sql
-rw-r--r-- 1 root root 3593936 Dez 6 2012 spatial_ref_sys.sql
-rw-r--r-- 1 root root 14036 Dez 6 2012 topology_comments.sql
-rw-r--r-- 1 root root 268175 Dez 6 2012 topology.sql
-rw-r--r-- 1 root root 267937 Dez 6 2012 topology_upgrade_20_minor.sql
-rw-r--r-- 1 root root 14314 Dez 6 2012 uninstall_legacy.sql
-rw-r--r-- 1 root root 36121 Dez 6 2012 uninstall_postgis.sql
-rw-r--r-- 1 root root 46839 Dez 6 2012 uninstall_rtpostgis.sql
-rw-r--r-- 1 root root 10189 Dez 6 2012 uninstall_topology.sql
Wäre sehr dankbar für ein wenig Hilfe.