[OSM-dev] Import error using osm2pgsql in slim mode

[Jason Beverage]

Hi all,

I'm working with osm2pgsql (latest trunk version) to import OSM into a
PostgreSQL/PostGIS database.  The issue I'm having is that if I use the
--slim option I'll occasionally get an error similar to:

Going over pending relations
COPY_END for COPY osm_rels FROM STDIN;
 failed: ERROR:  duplicate key value violates unique constraint
"osm_rels_pkey"
CONTEXT:  COPY osm_rels, line 1207: "284132    0    323
{42198453,20559277,20559273,20558263,20494565,40702583,19846737,19826462,20582455,20585..."

If I don't use slim mode, it seems to always work.  Right now I'm just
testing with state snapshots from http://downloads.cloudmade.com/, but I'd
like to be able to import the whole OSM planet database and I'd really like
to be able to use slim mode so I can do incremental updates and reduce the
memory requirements for importing.

Any help is greatly appreciated.

Thanks!

Jason
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20100121/e39775eb/attachment.html>