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

[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 createlang plpgsql.

The following resulted in some oddness. I'm wondering if I need to
re-install with macports, or one of the KyngChaos releases.. or I'm
just missing something. I appreciate thoughts.

Chris

=====================
$ 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
psql:/usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql:65: ERROR:
 current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql:70: ERROR:
 current transaction is aborted, commands ignored until end of
transaction block
...
...
...
ROLLBACK
psql:/usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql:7746:
ERROR:  type "geometry" does not exist
psql:/usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql:7747:
ERROR:  type "geometry" does not exist
...
psql:/usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql:7752:
ERROR:  type "box2d" does not exist
...
DROP FUNCTION
DROP FUNCTION
psql:/usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql:7775:
ERROR:  type "geometry" does not exist
=====================