[OSM-dev] [OSM-newbies] Should osm2pgsql create the planet_osm tables?

[Dave Stubbs]

On Jan 22, 2008 9:32 AM, Andy Robinson (blackadder) <
blackadderajr at googlemail.com> wrote:

> John,
>
> This is probably better spotted and hopefully responded to by the folks on
> the dev list. Copied there.
>
> Cheers
>
> Andy
>
> >-----Original Message-----
> >From: newbies-bounces at openstreetmap.org [mailto:newbies-
> >bounces at openstreetmap.org] On Behalf Of John Wheeler
> >Sent: 22 January 2008 7:10 AM
> >To: newbies at openstreetmap.org
> >Subject: [OSM-newbies] Should osm2pgsql create the planet_osm tables?
> >
> >Hi,
> >
> >My goal is to setup a renderfarm to generate my own maps. I setup a
> >postgresql with postgis and succeeded in compiling osm2pgsql from the
> >subversion repository. I also create a database called gis. In the readme
> >of osm2pgsql I read:
> >
> >Connects to database and creates the following 4 tables:
> >   - planet_osm_point
> >   - planet_osm_line
> >   - planet_osm_roads
> >   - planet_osm_polygon
> >
> >So what I understand is that osm2pgsql creates these tables before it
> >starts processing the planet file. However when I
> >run osm2pgsql with the following command
> >
> >./osm2pgsql -c -d gis  /opt/planet-latest.osm.bz2
> >
> >I get:
> >
> >osm2pgsql SVN version 0.51-20080121 $Rev: 6139 $
> >
> >Using projection SRS 3395 (WGS84 Mercator)
> >Setting up table: planet_osm_point
> >Setting up table: planet_osm_line
> >Setting up table: planet_osm_polygon
> >Setting up table: planet_osm_roads
> >
> >Reading in file: /opt/planet-latest.osm.bz2
> >Processing: Node(3640k) Way(0k) Relation(0k)
> >
> >but I see no tables being created in my gis database and when osm2pgsl is
> >ready I stil see no tables. Am I forgetting something or is there a ddl
> >script to create these tables? Any help is appreciated.
>

The tables are created and populated within a transaction, so you may not
see them appear until osm2pgsql has completely finished.
On my box this takes several hours for the latest planet, and spends at
least an hour with no output as postgres is indexing the data.
The output looks like it is working.

You might want to try it with a smaller subset of data first to check
everything is working. Any old .osm file will do, just download a small bbox
from the server (save from JOSM), and try and import that. It should happen
almost instantly and you can then check out the data in the tables.
Once you get that working you can import the 3.4GB of compressed planet.osm.

Dave
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20080122/567de850/attachment.html>