[OSM-dev] Rail Port timeout problem.

[Marcos Lois Bermúdez]

Hi,

I'm a entusiast of OSM, so i'm a bit time offline on osm develop, so i 
want to come back and contribute, so i downlaoded the rails port to 
setup a test server localy, i only want a api server for the moment to 
test Map editor.

I see a lot of changes in version 0.6, so here my problems and questions:

- I see that now it uses postgresql but in the rails port instructions i 
don't see any reference to postgis, so in my understand the database 
that holds osm data is not using postGIS at all, is this true? or the 
postgis extension are only used for mapnik as ia see in their 
installation instructions?

- I load the spain data into a postgres database setup for test, so i 
tune a bit the pg server, and install the rails port with the 
instructions of the wiki, so i get a lot of timeout problems triing to 
dowload a area form JOSM, it's a small area and i don't know how this 
get a long time, here the message that i recive for rail log:

[2009-08-06 13:00:51.754388 #4672] Processing ApiController#map (for 
192.168.0.104 at 2009-08-06 13:00:51) [GET]
[2009-08-06 13:00:51.754713 #4672]   Parameters: 
{"bbox"=>"-8.845367431640623,42.16493029974573,-8.553543090820312,42.27375234246751"}
...
...
[2009-08-06 13:20:52.237979 #4672] Completed in 1200483ms (View: 1, DB: 
1055) | 408 Request Timeout 
[http://192.168.0.144/api/0.6/map?bbox=-8.845367431640623,42.16493029974573,-8.553543090820312,42.27375234246751]

So i try with smallest one, and it get completed but i take a long time 
to download the data, the server a virtual machine running the database 
and the rails_port.

How can i solve the performance problem?, i try to search in the wiki, 
but i didn't found nothing.

I'm a ruby newbie, i'm more confortable with PHP, C and Java.

Another question is about import the data in the database, i finally use 
the osmosis in this form:

osmosis --read-xml  file="spain.osm.bz2" --write-apidb 
host="192.168.0.144" database="openstreetmap" user="openstreetmap" 
password="openstreetmap" dbType="postgresql" validateSchemaVersion="no"

since with --write-pgsql i get a lot of error about missing tables, for 
what is  --write-pgsql?

So if i can help contributing in some are, tell me, i'm getting data to 
complete maps here near my location, so i want also get invoilved in 
development in OSM, since its a great project.

Regards.