Hi Nakor,
You're getting an error earlier in the script:
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
You don't appear to have the PostGIS SRID tables populated. I don't have
details handy on how to do this, but your PostGIS distribution should
include a script for doing this ...
I'll look again later when I have a PostgreSQL system available.
Brett
On Thu, Jul 22, 2010 at 10:16 AM, Nakor <[email protected]> wrote:
> 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
>
_______________________________________________
osmosis-dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/osmosis-dev
