Re: [OSM-dev] troubles importing osm data via osm2pgsql: skipping table creation, no function match, permission issue?

2010-08-09 Thread Christopher Stevens
This item has been resolved. I switched to from Mac OSX 10.6 to ubuntu for improved success, following directions with minor improv at: http://trac.mapnik.org/wiki/UbuntuInstallation ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.o

Re: [OSM-dev] troubles importing osm data via osm2pgsql: skipping table creation, no function match, permission issue?

2010-08-07 Thread Christopher Stevens
> Do you have postgis libraries installed? I'm guessing yes. Maybe I need to set a 'libdir' PATH? Here's what I can find so far: $ locate postgis-1.5 /usr/local/pgsql/lib/postgis-1.5.so /usr/local/pgsql/share/contrib/postgis-1.5 /usr/local/pgsql/share/contrib/postgis-1.5/new_p

Re: [OSM-dev] troubles importing osm data via osm2pgsql: skipping table creation, no function match, permission issue?

2010-08-07 Thread John Smith
On 8 August 2010 03:20, Christopher Stevens wrote: > $ psql -d gis -f /usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql > SET > BEGIN > psql:/usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql:59: ERROR: > could not access file "$libdir/postgis-1.5": No such file or > directory Do you ha

Re: [OSM-dev] troubles importing osm data via osm2pgsql: skipping table creation, no function match, permission issue?

2010-08-07 Thread Christopher Stevens
> [*] postgis.sql for PostGIS 1.4 and later I believe. I'm using postgis-1.5, installed using homebrew > There's two files named lwpostgis.sql* and spatial_ref_sys.sql which are in > your PostGIS package somewhere. You need to run them on your database after > you have done the createdb and the

Re: [OSM-dev] troubles importing osm data via osm2pgsql: skipping table creation, no function match, permission issue?

2010-08-07 Thread Frederik Ramm
Hi, On 08/07/2010 04:29 PM, Christopher Stevens wrote: No luck. Maybe it's not a permission issue, or I'm missing a step? Let me know what you think. I appreciate the feedback. There's two files named lwpostgis.sql* and spatial_ref_sys.sql which are in your PostGIS package somewhere. You need

Re: [OSM-dev] troubles importing osm data via osm2pgsql: skipping table creation, no function match, permission issue?

2010-08-07 Thread John Smith
On 8 August 2010 00:29, Christopher Stevens wrote: > No luck. Maybe it's not a permission issue, or I'm missing a step? Let > me know what you think. I appreciate the feedback. You seem to be missing the postgis functions: > failed: ERROR: function addgeometrycolumn(unknown, unknown, integer,

[OSM-dev] troubles importing osm data via osm2pgsql: skipping table creation, no function match, permission issue?

2010-08-07 Thread Christopher Stevens
OS: Mac OSX 10.6 Terminal output: $ time /usr/local/bin/osm2pgsql --slim -d gis /users/chris/Desktop/coloradoOSM/colorado.osm.highway osm2pgsql SVN version 0.69-exported Using projection SRS 900913 (Spherical Mercator) Setting up table: planet_osm_point NOTICE:  table "planet