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

[Andy Robinson (blackadder)]

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.
>
>John