Re: [OSM-dev] load-osm.sh

2014-10-14 Thread Hartmut Holzgraefe
On 10/13/2014 09:52 AM, Sven Geggus wrote: Jepp. I already did something like this myself. A disadvatage of the approach is, that there is no way to dump indexes, they have to be re-created on the target machine while running pg_restore. one of the reasons why I was working on a mysql output

[OSM-dev] load-osm.sh

2014-10-13 Thread Ilya Zverev
Paul Norman wrote: On 10/12/2014 2:49 PM, Ilya Zverev wrote: Hi! Yesterday I had a simple task: there is a rendering server, which is not to be minutely updated. So its PostgreSQL database doesn't need temporary slim tables. But I cannot import an extract without creating those, so basically I

Re: [OSM-dev] load-osm.sh

2014-10-13 Thread Sven Geggus
Ilya Zverev i...@zverev.info wrote: The solution is obvious: I rented a huge hourly-priced droplet, installed postgresql and osm2pgsql there, imported a big OSM extract, deleted slim tables and transferred database contents to said rendering server. Jepp. I already did something like this

Re: [OSM-dev] load-osm.sh

2014-10-13 Thread Paul Norman
On 10/13/2014 12:52 AM, Sven Geggus wrote: I still think distributing sql updates for rendering databases in addition to osm diffs would be a nice to have feature, because the state of the osm database is of no interest to a rendering database. I never tried to implement this though. How I'd

[OSM-dev] load-osm.sh

2014-10-12 Thread Ilya Zverev
Hi! Yesterday I had a simple task: there is a rendering server, which is not to be minutely updated. So its PostgreSQL database doesn't need temporary slim tables. But I cannot import an extract without creating those, so basically I can import 3 times less data than possible. The solution is

Re: [OSM-dev] load-osm.sh

2014-10-12 Thread Paul Norman
On 10/12/2014 2:49 PM, Ilya Zverev wrote: Hi! Yesterday I had a simple task: there is a rendering server, which is not to be minutely updated. So its PostgreSQL database doesn't need temporary slim tables. But I cannot import an extract without creating those, so basically I can import 3 times