You are not logged in.
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
Offline