[Tilesathome] Setting up ROMA

[Florian Lohoff]

On Wed, Dec 03, 2008 at 11:32:09AM -0500, Matthias Julius wrote:
> I am attempting to follow the trend and set up my own ROMA server.
> Unfortunately that does not goes as smooth as I would wish.
> 
> I am following the instructions at
> http://wiki.openstreetmap.org/index.php/Read_Only_Map_API
> 
> When applying the database schema psql complains while creating an
> index:
> 
> ERROR:  column "bbox" does not exist

The bbox column is obsolete - its not necessary for the SQL of ROMA
and creating the bbox on import runs forever (as it does a full table
scan on the nodes table per way)

> Then, on the planet import osmosis dies with:
> 
> ERROR: index "idx_ways_bbox" does not exist
> 
> Is there a trick that is not mentioned on the wiki page?
> 
> One little discrepancy I noticed is that osmosis-0.29-patch is
> patching script/pgsql_simple_schema.sql contrary to the listing on the
> wiki.

It should patch it - as it patches osmosis. So the bbox column should not be
created using the patches schema - and the patched (and dont forget to
rebuild) osmosis shouldnt need it ...

Flo
-- 
Florian Lohoff                  flo at rfc822.org             +49-171-2280134
	Those who would give up a little freedom to get a little 
          security shall soon have neither - Benjamin Franklin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.openstreetmap.org/pipermail/tilesathome/attachments/20081203/66ddd3d8/attachment.pgp>