[postgis-users] error loading postgis.sql on OS X 10.3 server

[Alex Rice]

Hi I'm back. Trying to upgrade my PostGIS installation it turned out to  
be tough to get the pieces all together, as usual!

The error, shown below, sounds as if my Pgsql is not compiled with C++  
support, but I did indicate stdc++ on the configure options for Pgsql  
(for GEOS support) Any ideas where I went wrong?

gcc -v
Reading specs from /usr/libexec/gcc/darwin/ppc/3.3/specs
Thread model: posix
gcc version 3.3 20030304 (Apple Computer, Inc. build 1495)

PostgreSQL 7.4.1
	./configure --with-perl --with-rendezvous --without-readline  
LDFLAGS="-lstdc++ -L/usr/local/lib"

PostGIS 0.8.1
	Makefile: USE_PROJ = 0, GEOS = 1, USE_STATS = 0

Here is the error loading postgis.sql:

# /usr/local/pgsql/bin/psql -U postgres -f  
/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql -d  
aps
BEGIN
         message
------------------------
  PL/PgSQL is installed.
(1 row)

psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql: 
44: NOTICE:  type "histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
psql:/usr/local/src/postgresql-7.4.1/contrib/postgis-0.8.1/postgis.sql: 
44: 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-7.4.1/contrib/postgis-0.8.1/postgis.sql: 
49: ERROR:  current transaction is aborted, commands ignored until end  
of transaction block
... snip rest of errors ..

--
Alex Rice, Software Developer
Architectural Research Consultants, Inc.
<http://ARCplanning.com>