<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body bgcolor="#ffffff" text="#000000">
I read all data using dumping and copy (fastest way).<br>
<br>
1) For the PBF version this failed, because of 2 errors (!) in the
nodes dump. 2 timestamps were malformed like this: "2005-08-01
21:11:38)0200" instead of "2005-08-01 21:11:38+0200"<br>
So all tables were populated but the nodes table. From the Postgres
docs:<br>
<br>
"<span class="Apple-style-span" style="border-collapse: separate;
color: rgb(0, 0, 0); font-family: Times; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing: normal;
line-height: normal; orphans: 2; text-indent: 0px; text-transform:
none; white-space: normal; widows: 2; word-spacing: 0px;
font-size: medium;"><span class="Apple-style-span"
style="font-family: verdana,sans-serif; font-size: 12px;
line-height: 18px; text-align: left;"><tt class="COMMAND"
style="font-size: 1.2em;">COPY</tt><span
class="Apple-converted-space"> </span>stops operation at the
first error. This should not lead to problems in the event of a<span
class="Apple-converted-space"> </span><tt class="COMMAND"
style="font-size: 1.2em;">COPY TO</tt>, but the target table
will already have received earlier rows in a<span
class="Apple-converted-space"> </span><tt class="COMMAND"
style="font-size: 1.2em;">COPY FROM</tt>. These rows will not
be visible or accessible, but they still occupy disk space.</span></span>"<br>
<br>
It seems that there is no way to ignore malformed CSV lines. I think
using triggers is a bad idea because it will degrade performance.<br>
<br>
2) Today I have tried the same with the OSM.BZ2 version. But the bz2
is malformed, I cannot decompress it.<br>
<br>
I would try to read the whole planet, if my current server setup
would allow it. So I am very thankful that geofabrik provides the
dumps, and I hope this helps to make your service better.<br>
<br>
Smaller dumps of the Bundesländer seem to work. Now I will give the
europe dump a try.<br>
<br>
Andi<br>
<br>
<br>
<br>
<br>
<br>
<br>
</body>
</html>