Hello,
Is there a good documentation for how to setup a postgresql base for
osmosis. I've read thru OpenStrettMap wiki and it is quite hard to
understand waht exact schema you need to use.
I tired to use pgsql_simple_schema_0.6.sql but got errors (see below)
and then when I run osmosis it complains about index "idx_nodes_geom"
not existing.
Thanks in advance,
N.
-bash-4.1$ psql -d local -f /tmp/pgsql_simple_schema_0.6.sql
[...]
psql:/tmp/pgsql_simple_schema_0.6.sql:42: ERROR: AddGeometryColumns() -
invalid SRID
CONTEXT: SQL statement "SELECT AddGeometryColumn('','', $1 , $2 , $3 ,
$4 , $5 )"
PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement
[...]
INSERT 0 1
psql:/tmp/pgsql_simple_schema_0.6.sql:111: NOTICE: ALTER TABLE / ADD
PRIMARY KEY will create implicit index "pk_schema_info" for table
"schema_info"
ALTER TABLE
psql:/tmp/pgsql_simple_schema_0.6.sql:113: NOTICE: ALTER TABLE / ADD
PRIMARY KEY will create implicit index "pk_users" for table "users"
ALTER TABLE
psql:/tmp/pgsql_simple_schema_0.6.sql:115: NOTICE: ALTER TABLE / ADD
PRIMARY KEY will create implicit index "pk_nodes" for table "nodes"
ALTER TABLE
psql:/tmp/pgsql_simple_schema_0.6.sql:117: NOTICE: ALTER TABLE / ADD
PRIMARY KEY will create implicit index "pk_ways" for table "ways"
ALTER TABLE
psql:/tmp/pgsql_simple_schema_0.6.sql:119: NOTICE: ALTER TABLE / ADD
PRIMARY KEY will create implicit index "pk_way_nodes" for table "way_nodes"
ALTER TABLE
psql:/tmp/pgsql_simple_schema_0.6.sql:121: NOTICE: ALTER TABLE / ADD
PRIMARY KEY will create implicit index "pk_relations" for table "relations"
ALTER TABLE
CREATE INDEX
psql:/tmp/pgsql_simple_schema_0.6.sql:126: ERROR: column "geom" does
not exist
[...]
_______________________________________________
osmosis-dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/osmosis-dev
