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

[Martijn Verwijmeren]

Hi,

The script should create the tables, you don't have to do that
yourself. However you don't mention how you created your database. Did
you follow all three steps:
* createdb
* createlang
* run lwpostgis.sql
as described in:
http://wiki.openstreetmap.org/index.php/Mapnik#Create_Database

On Tue, 22 Jan 2008 08:10:24 +0100
"John Wheeler" <johnny.wheeler at gmail.com> wrote:

> 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