[OSM-dev] installing own osm api server

[Jeff Meyer]

Shaun - your answer is helpful, but does it answer Martin's question?

Would it be better to set up the indexes and constraints after the import?
Does it matter?

Thanks, Jeff

On Tue, Apr 2, 2013 at 1:38 PM, Shaun McDonald <shaun at shaunmcdonald.me.uk>wrote:

> Hi,
>
> Changing some of the parameters for the Postgres database can help speed
> up the import in a similar manner to those settings for a Mapnik import.
>
> Shaun
>
> On 2 Apr 2013, at 19:58, Martin Schafran <martin at ampelmeter.com> wrote:
>
> >
> > hi,
> >
> > im trying to install my own osm server with api 0.6.
> >
> > following instructions i stuck on database import.
> >
> > http://wiki.openstreetmap.org/wiki/Rails_port#Database_tables
> >
> > at this point all indexes and constraints are created before import.
> >
> > Is this really the correct approach? indexes and constraints make import
> slow.
> >
> > btw. i got 'duplicate key value violates unique constraint
> > "current_nodes_pkey1"
> >  Detail: Key (id)=(12) already exists.'
> >
> >  :-O  source is geofabrik germany extract.
> >
> >
> > martin
> >
> > _______________________________________________
> > dev mailing list
> > dev at openstreetmap.org
> > http://lists.openstreetmap.org/listinfo/dev
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
>



-- 
Jeff Meyer
Global World History Atlas
www.gwhat.org
jeff at gwhat.org
206-676-2347

OpenStreetMap: Mapping with a Human Touch
<http://www.openstreetmap.org/user/jeffmeyer> osm: Open Historical Map
(OHM)<http://wiki.openstreetmap.org/wiki/Open_Historical_Map>
 / my OSM user page <http://www.openstreetmap.org/user/jeffmeyer>
 t: @GWHAThistory <https://twitter.com/GWHAThistory>
 f: GWHAThistory <https://www.facebook.com/GWHAThistory>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20130412/7c5f64c3/attachment-0001.html>