[OSM-dev] problems with planetosm-to-db.pl
m b
life_in_a_radioactive_dustbin at hotmail.com
Wed Nov 7 16:25:17 GMT 2007
Hello.
I'm fairly new to the development side of OSM, so please bear with me. I am trying to create a PostgreSQL database of a planet.osm dump of the UK, which I would eventually like to use to extract Illustrator files using OSM2AI.
I'm on a mac running 10.4.10, logged in as the 'postgres' user. I have installed PostgreSQL (8.2.5) and PostGIS (1.3.1), and am using the default database 'postgres'.
My first step is to load the PL/pgSQL language:
-----
mb:~ postgres$ /usr/local/pgsql/bin/createlang plpgsql postgres
Follwed by the postGIS object:
-----
mb:~ postgres$ /usr/local/pgsql/bin/psql -d postgres -f /usr/local/pgsql/share/lwpostgis.sql
And the spatial references:
-----
mb:~ postgres$ /usr/local/pgsql/bin/psql -d postgres -f /usr/local/pgsql/share/spatial_ref_sys.sql
I then execute planetosm-to-db.pl:
-----
mb:~ postgres$ perl planetosm-to-db.pl Planet.osm
Which generates an error:
-----
DBD::Pg::st execute failed: ERROR: relation "nodes" does not exist
What does this error mean? I have tried searching for information about it but can't seem to find much about it, other than it is an error generated by one of the perl modules. Is it something I have done wrong on the command line, or is it something to do with the script? I'd be grateful for any help you could give me.
_________________________________________________________________
The next generation of MSN Hotmail has arrived - Windows Live Hotmail
http://www.newhotmail.co.uk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20071107/0858b53b/attachment.html>
More information about the dev
mailing list