[OSM-dev] Using osmosis for a daily from-scratch import into PostgreSQL and SQLite support

[Ævar Arnfjörð Bjarmason]

On Wed, Mar 3, 2010 at 01:21, Brett Henderson <brett at bretth.com> wrote:
> Hi Ævar,
>
> Can you provide the full error output from Osmosis.  I suspect there's a
> "caused by" nested exception that provides the root cause for the error.

After some more debugging it turns out that the issue is simply that
the script/*.sql files are very out of date and in no way reflect the
current DB schema or the tables that osmosis tries to insert into.

In the attached patch I fixed some of these but it doesn't fix all the
issues, the current_* tables are still missing. It would be nice if
one could skip importing into current_* for one-off imports like
these.

> As for SQLite support, it's a nice idea but a non-trivial amount of work.
> I'm happy to give somebody guidance on adding it, but I don't have time
> myself.

Ok :)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sql.diff
Type: text/x-patch
Size: 5770 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20100303/d0b62aaa/attachment.bin>