Fwd: [postgis-users] error loading postgis.sql on OS X

[Michael Choy]

I have had success with Postgis on OS X Server 10.3.5 in two ways:

1) Using gcc 3.4 as described by this very useful tutorial:  
http://spanring.name/postgis.html  I used this to achieve a working  
setup with:
Postgresql 7.4.3
Postgis 0.8.2
GEOS 1.0

2) Using gcc 3.3 (XCode 1.1) with:
Postgresql 8.0b1
Postgis 0.8.2 CVS
GEOS 2.0.0

I am currently using setup #2, as I would occasionally get weird GEOS  
errors using #1. Good luck.

Michael Choy


> Message: 2
> Date: Mon, 06 Sep 2004 13:25:36 -0400
> From: Joshua Lieberman <josh at oklieb.net>
> Subject: Re: Fwd: [postgis-users] error loading postgis.sql on OS X
> 	10.3.3
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <413C9D90.6080308 at oklieb.net>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> I too have not solved this problem. It appears that stdc++ is being
> linked in as a dynamic library but is only available in the OS X
> distribution as a static archive (.a). I have neither tracked down a
> dynamic library file (.dyld.so) nor gone so far as to rebuild gcc 3.3  
> to
> see if I can get on. Someone did build gcc3.4 and succeeded in loading
> the PostGIS procedures, but conflicts between codes compiled with the
> two different gcc versions appear wreaked havoc for them with other
> software.
>
> Would certainly appreciate help from someone more familiar with OS X  
> C++
> development to resolve this.
>
> Thanks in advance,
>
> Josh Lieberman
>
>
>
> Benoit Ogier wrote:
>
>> Hi,
>>
>> I'm new on postgis, and Mac OS X user... I found this message of
>> january and I got same error under OS 10.3.3 with postgres 7.4.5, GCC
>> 3.3, and postgis 0.8.2, when using GEOS 1.0.
>> Did someone find any solution for this trouble ???
>>
>> My config line for postgress :
>> LDFLAGS=-lstdc++ ./configure -bindir=/usr/local/bin
>> --mandir=/usr/local/share/man/ --enable-recode --with-CXX
>> --enable-odbc --enable-syslog --enable-unicode-conversion
>> --enable-multibyte
>>
>> Thanks,
>>
>> BO
>>
>>     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 ..