The rpms installed ok but when I went to install postgis into a test database by issuing the following commands:
> createdb $DBNAME
> createlang plpgsql $DBNAME
> psql -q -f /usr/share/pgsql/contrib/lwpostgis.sql -d $DBNAME
I get an error at this point (or rather, a bunch of errors but the first one is most relevant):
psql:/usr/share/pgsql/contrib/lwpostgis.sql:47: NOTICE: type "histogram2d" is not yet defined
DETAIL: Creating a shell type definition.
psql:/usr/share/pgsql/contrib/lwpostgis.sql:47: ERROR: could not access file "/postgis.so": No such file or directory
psql:/usr/share/pgsql/contrib/lwpostgis.sql:52: ERROR: current transaction is aborted, commands ignored until end of transaction block
I found another email that mentioned a similar problem (
http://lists.refractions.net/pipermail/postgis-users/2006-June/012479.html) but no one responded. The workaround for that person was to remove the leading / before the postgis.so references. Is this a known issue or some sort of misconfiguration on my part?
Thanks,
Corey