Re: [osmosis-dev] ERROR: insert or update on table current_way_nodes

2010-07-21 Thread Klemens
Intel Core i7-920 Quad-Core, 8 GB DDR3 RAM, 2 x 750 GB SATA-II HDD (Software-RAID 1) On 21.07.2010 12:58, Kirill Bestoujev wrote: 23 days??? What kind of hardware do you use??? And yes, the database is unusable, the import did not finish. Kirill 2010/7/21 Klemens toural...@gmail.com

Re: [osmosis-dev] ERROR: insert or update on table current_way_nodes

2010-07-21 Thread Klemens
not in the end of the process - les then half of nodes were imported in current tables, so the import was far from end... try to use the buffer command, it may help to increase the speed. Kirill 2010/7/21 Klemens toural...@gmail.com: Intel Core i7-920 Quad-Core, 8 GB DDR3 RAM, 2 x 750 GB

Re: [osmosis-dev] Need Help

2010-06-11 Thread Klemens
What is the error message that you get? On 11.06.2010 13:38, PARVEEN ARORA wrote: Hello Every one, I am Parveen Arora .An engineering student. I am doing a project of setting osm -server for Our state punjab in India and to develop its and features of Main OpenStreetMap. i have followed

[osmosis-dev] rails_port and Mapnik with one database

2010-06-09 Thread Klemens
, and the osm2pgsql another ~115 GB. Thanks, Klemens ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev

Re: [OSM-dev] Exporting data is really slow

2010-04-13 Thread Klemens
. What is api.openstreetmap.org using for exporting to xml? The C based exporter or the rails_port? On 11.04.2010 13:51, Shaun McDonald wrote: On 9 Apr 2010, at 17:22, Klemens wrote: Hi, I set up a rails_port on a new server using PostgreSQL 8.3 and imported the europe.osm data. Now exporting

[OSM-dev] Exporting data is really slow

2010-04-09 Thread Klemens
Hi, I set up a rails_port on a new server using PostgreSQL 8.3 and imported the europe.osm data. Now exporting xml using the 0.6 API is really slow. Exporting a file of about 3.2 MB takes 25 seconds. In the development.log file I get lines like this: [2010-04-09 18:11:21.569386 #27182] Completed

Re: [osmosis-dev] Database is empty after five days of importing

2010-03-25 Thread Klemens
Thanks. Any hints on how this can be done with osmosis? On 24.03.2010 21:12, Peter Körner wrote: Import in a transaction. ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev

Re: [osmosis-dev] Database is empty after five days of importing

2010-03-24 Thread Klemens Z
You're right, it's no fun at all. Well here's what I did to try it with a smaller country excerpt (102 MB compressed) this night: nohup bzcat ~/install/osm-dumps/austria.osm.bz2 | ./osmosis-0.34/bin/osmosis --read-xml-0.6 file=- --write-apidb-0.6 populateCurrentTables=yes host=localhost

Re: [osmosis-dev] Database is empty after five days of importing

2010-03-24 Thread Klemens
by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint nodes_pkey' while testing with the old DB. So at some time in the future when I want to import Europe into a DB that contains Austria I will have to create a delta .osm first using osmosis? On 24.03.2010 10:34, Klemens Z

Re: [osmosis-dev] Database is empty after five days of importing

2010-03-24 Thread Klemens
That makes sense. My requirement is that I must continue querying the old data while importing the new, larger data - which can take a long time as we know. How can I achieve this? On 24.03.2010 19:24, Frederik Ramm wrote: Possible, but impractical, because you would spend more time to create

[osmosis-dev] Database is empty after five days of importing

2010-03-23 Thread Klemens Z
in it. select * from nodes; returns 0 rows. Can anybody tell me what happened? Thanks, Klemens ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev