[ gpsdrive ] install-mapnik-osm.txt

[haylocki]

Hi, I have been trying to get the instructions in this file to work.

After 2 days of fighting with postgresql and this file, I finally give up
:confused:

I am having a problem with this section of the instructions :

# ----------- Create Database Import the dump from
http://www.gpsdrive.de/osm/
1  sudo -u postgres createdb -Upostgres  -EUTF8 gis  
2  sudo -u postgres createuser -Upostgres -S -D -R osm
3  echo "GRANT ALL on geometry_columns TO \"$user_name\";" | \
4  export user_name="tweety"
5  sudo -u postgres psql -Upostgres gis
6  echo "GRANT ALL ON SCHEMA PUBLIC TO \"osm\";" | sudo -u postgres psql
-Upostgres gis
7  gunzip -dc ~/osm/mapnik-osm-gis.sql.gz | \
8        sed "s/tweety/osm/g" | \
9	sudo -u postgres psql -Upostgres gis | \
10	grep -v -e "ALTER FUNCTION" -e "CREATE FUNCTION" -e "DROP FUNCTION"

At first even the first 2 lines would not work, but after fighting with
postgresql and Ubuntu they finally worked (I have no clue as to why&-()

the third and forth lines : 
echo "GRANT ALL on geometry_columns TO \"$user_name\";" | \
  export user_name="tweety"

just report the error "broken pipe"echo "

so I joined the two lines to make :

GRANT ALL on geometry_columns TO \"$user_name\";" | export
user_name="tweety"

and that seems to work

Then I enter line 5 and I enter the postgresql interactive terminal

Now surely line 6 requires me to be in a bash shell ? so what is line 5 for
?

So now I \q back to bash and enter line 6

that just returns "GRANT"

then I concatenate lines 7-10 and get the following output :


SET
SET
SET
SET
ERROR:  index "z_index3" does not exist
ERROR:  index "z_index2" does not exist
ERROR:  index "z_index1" does not exist
ERROR:  index "z_index0" does not exist
ERROR:  index "way_index3" does not exist
ERROR:  index "way_index2" does not exist
ERROR:  index "way_index1" does not exist
ERROR:  index "way_index0" does not exist
ERROR:  relation "public.spatial_ref_sys" does not exist
ERROR:  relation "public.geometry_columns" does not exist
ERROR:  table "spatial_ref_sys" does not exist
ERROR:  table "planet_osm_roads" does not exist
ERROR:  table "planet_osm_polygon" does not exist
ERROR:  table "planet_osm_point" does not exist
ERROR:  table "planet_osm_line" does not exist
ERROR:  table "geometry_columns" does not exist

plus a whole load more errors

What am I doing wrong :confused:

Cheers, Ian



-- 
View this message in context: http://www.nabble.com/install-mapnik-osm.txt-tf4298358.html#a12234443
Sent from the GpsDrive mailing list archive at Nabble.com.