[postgis-users] failure to load postgis.sql

[Byron Amerson]

Hello,

Finally have compiled postgis-0.80 for my mac running osx10.3.1 with
postgresql-7.4. I also have proj4 and geos compiled as well. No problems
there.

but when attempting to load postgis.sql I get the following error:

[Tectonic:~] postgres% psql -d gistest -f
/usr/local/src/postgresql/postgresql-7.4/contrib/postgis-0.8.0/postgis.sql
BEGIN
        message
------------------------
 PL/PgSQL is installed.
(1 row)

psql:/usr/local/src/postgresql/postgresql-7.4/contrib/postgis-0.8.0/postgis.sql:41:
NOTICE:  type "histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
psql:/usr/local/src/postgresql/postgresql-7.4/contrib/postgis-0.8.0/postgis.sql:41:
ERROR:  could not load library "/usr/local/pgsql/lib/libpostgis.so.0.8":
dyld: /usr/local/pgsql/bin/postmaster Undefined symbols:
__ZNSs20_S_empty_rep_storageE
__ZNSs4_Rep11_S_max_sizeE
__ZNSs4_Rep11_S_terminalE
__ZNSt24__default_alloc_templateILb1ELi0EE12_S_force_newE
__ZNSt24__default_alloc_templateILb1ELi0EE12_S_free_listE
__ZNSt24__default_alloc_templateILb1ELi0EE22_S_node_allocator_lockE
__ZTIPv
__ZTVN10__cxxabiv117__class_type_infoE
__ZTVN10__cxxabiv119__pointer_type_infoE
__ZTVN10__cxxabiv120__si_class_type_infoE
__ZTVN10__cxxabiv121__vmi_class_type_infoE
___cxa_pure_virtual
___gxx_personality_v0

psql:/usr/local/src/postgresql/postgresql-7.4/contrib/postgis-0.8.0/postgis.sql
:46: ERROR:  current transaction is aborted, commands ignored until end of
transaction block

...etc...

Any suggestions?? Thanks for any help in advance.


Byron Amerson
MS student
University of Washington
Department of Earth and Space Sciences