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" <[EMAIL PROTECTED]> 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 _______________________________________________ newbies mailing list [email protected] http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/newbies
