Arch Linux

walterjwhite

Member

Registered: 2011-05-01

Posts: 207

gpsdrive - trouble installing

Hi all,

I am attempting to install gpsdrive and when I am inserting the map data, I get this error:

Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE:  table "planet_osm_point" does not exist, skipping
NOTICE:  table "planet_osm_point_tmp" does not exist, skipping
SELECT AddGeometryColumn('planet_osm_point', 'way', 900913, 'POINT', 2 );
failed: ERROR:  permission denied for relation spatial_ref_sys
CONTEXT:  SQL statement "SELECT SRID         FROM spatial_ref_sys WHERE SRID = new_srid"
PL/pgSQL function "addgeometrycolumn" line 74 at SQL statement
SQL statement "SELECT AddGeometryColumn('','',$1,$2,$3,$4,$5)"
PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement

Error occurred, cleaning up

I am running this command:
osm2pgsql -s --database "UnitedStates" --username "gis" --password --multi-geometry "/home/walterjwhite/Downloads/united_states.osm.bz2"

Any ideas what I may be missing?  It appears to be a permissions issue.

Walter