Tom Hughes írta:
> Use PostgreSQL not MySQL - the MySQL support is not really maintained
> anymore so it likely to be extremely fragile as you've just discovered.
Thanks for the tip, I successfully ran "rake db:migrate". However, I failed to 
upload
some maps.

I've tried to run:
--------
osmosis --read-xml file="hungary.osm.bz2" --write-apidb-0.6 host="localhost"
database="openstreetmap" user="openstreetmap" password="openstreetmap"
validateSchemaVersion=no
--------
however, it failed with an exception.
The root cause seems to be:
--------
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique 
constraint
"nodes_pkey"
--------

I've seen a thread on this list about a similar error here:
http://www.mail-archive.com/[email protected]/msg08498.html, but there was 
no real
solution except to try to fix the OSM file itself (which I would very much like 
to not
to do).

By the way, 'osmosis --read-xml file="hungary.osm.bz2" --write-xml"' succeeds.

Thank you in advance for any tips,

        PP


_______________________________________________
dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/dev

Reply via email to