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

Wed Sep 8 03:14:13 PDT 2004

Hi, i'm back...

I succed on OS X 10.3.3 with Christian Spanring method  
(http://spanring.name/postgis.html) with :
Gcc 3.4.1
Readline 5.0 (just for postgres...)
Postgresql 7.4.5
Postgis 0.8.2
Geos 1.0
Proj-4.4.8

It seem's it works but i can't directly use geometry columns for  
geometric functions...
with a table "test" and a column "geom" :
"select area(geom) from test" returns 0 for each record,
"select area(geomfromtext(geom)) from test" returns the real value.

Did I miss something in postgis sql commands, or is it a bug due to my  
installation ???

Thanks in advance,

BO

Le 7 sept. 04, à 07:44, Michael Choy a écrit :

> 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 ..
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-- 
Benoît Ogier{
Carte Blanche Conseil
47, rue de Lancry
75010 Paris
Tel : +33 1 42 41 21 21
Fax : +33 1 42 41 70 40
email : benoit.ogier at cbconseil.com
};
-- 