[ gpsdrive ] database problems

[Joerg Ostertag (gpsdrive Munich/Germany)]

On Donnerstag 24 Januar 2008, carlo mecozzi wrote:
> what should I finally do to use openstreetmap?
>
> this is the last output after havin installed everything needed:
>
>
>   carlo at carlo-desktop:~$ sudo mapnik-osm-updater.sh --create-db
> ----- Create Database 'gis'

The probably easiest methods are the two following.  They do all the creation
steps,  including mirroring a planet file, creation of system users, creation 
of database users, ...

If you want to have the complete planet File of the world. Warning this is 
large !
  --all-planet

If you only want to use smaller excerpts. For example europe only, ...
  --all-planet-geofabrik=val    
Since the current debian mapnik has some slight problems while initializing. I 
would currently recomment to only use a planet file of the size of Germany..
use  
	--all-planet-geofabrik=?
to get a list of available planet Files on Frederics Page.


> createdb: database creation failed: ERROR:  database "gis" already exists
> Creation Failed

This warning is OK, but the command does not everything you will need. You 
might want to have a look at the ones above.

> carlo at carlo-desktop:~$ sudo mapnik-osm-updater.sh --grant-db-users=*
> GRANT Rights to every USER
> Granting rights to users: ' carlo'
> Granting all rights to user 'carlo' for Database 'gis'
> ERROR:  relation "geometry_columns" does not exist
> ERROR:  role "carlo" does not exist
> ERROR:  relation "spatial_ref_sys" does not exist
> ERROR:  relation "planet_osm_line" does not exist
> ERROR:  relation "planet_osm_point" does not exist
> carlo at carlo-desktop:~$

after submitting the -all-planet-xxx this command should be more successfull.

-
Joerrg