[postgis-users] Help urgently needed - geomfromEWKT() / PostGIS on Mac OS X

[Christian Heine]

Dear list,
I've been battling with major problems installing PostGIS-1.1.1 over  
the recent days and I am not sure what do anymore. Maybe it's the  
blindness of having to fix this asap with pressing last weeks of a  
PhD in the back, maybe some technical stuff. Definitely I need some  
external comments on my attempts from you experts.

I had a well working system on a Dual G5 with Mac OS X 10.4 mid -last  
year with Postgresql 8.0.3/PostGIS 1.0.0 (I think it was 1.0.0-rc)  
after trying to upgrade it to PostGIS 1.1.1 the geomfromEWKT   
function doesn't seem to be working anymore - I can't use the  
geomfromEWKT() function anymore, which I used extensively in  
PostGIS-1.0.0 (This is both on a Dual G5 PowerMac and a G4 Powerbook  
with the inital same setting).

After trying to figure out the cause of the problem (see the libgeom*  
messages earlier on this list between a very responsive an helpful  
strk and me) I decided to wipe the whole system and revert to my old  
setting with geos 2.1.1, proj-4.4.9, postgresql-8.0.3 and  
postgis-1.0.0(?rc) even this doesn't work - even the installation  
with W. Kingesburye's pre-compiled pgsql-8.1.2/p-gis-1.1.1  
(www.kyngchaos.com) doesn't work (getting the geomfromewkt() doesn't  
exist message , see below).

Here's what I did:

1) OS 10.4. (clean install), XCode 2.0, gcc4.0, readline from fink:
	-proj-4.4.9 compiles/works fine
	-geos-2.2.1 compiles works fine
	-postgresql-8.1.2 with the following configuration:
	./configure --with-readline --with-includes=/sw/include/\
		--with-libraries=/usr/local/lib --with-openssl --with-bonjour -- 
with-pam\
		--with-perl --enable-thread-safety LDFLAGS="-lstdc++ -L/usr/local/lib"
	make check: all tests passed.

	- postgis-1.1.1 - compiles fine - seems to be working.
		psql testdb < lwpostgis.sql
		psql testdb < spatial_ref_sys.sql
		with no errors.
	- loading a 3D polygon with [...]geomfromEWKT('POLYGON((29.212389  
-81.033350 10, 29.211220 -81.033817 10, 29.210930 -81.033338 10,  
29.211520 -81.030326 10, 29.212582 -81.030461 10, 29.212389  
-81.033350 10))',-1) ---> this is from E. Cordery's message (04.02.2006)
	--> ERROR: geomfromEWKT("unknown", integer) does not exist

2) 10.4. (clean install) XCode2.0, gcc3.3, readline from fink
	-proj-4.4.9 compiles/works fine
	-geos-2.1.1 compiles works fine
	-postgresql-8.0.3 with the following configuration:
	./configure --with-readline --with-includes=/sw/include/\
		--with-libraries=/usr/local/lib --with-openssl --with-bonjour -- 
with-pam\
		--with-perl --enable-thread-safety LDFLAGS="-lstdc++ -L/usr/local/lib"
	make: ERROR /usr/bin/libtool: internal link edit command failed -  
Undefined symbols

3) 10.4. (clean install) XCode2.0, gcc4.0, readline from fink
	-proj-4.4.9 compiles/works fine
	-geos-2.2.1 compiles works fine
	-postgresql-8.0.3 with the following configuration:
	./configure --with-readline --with-includes=/sw/include/\
		--with-libraries=/usr/local/lib --with-openssl --with-bonjour -- 
with-pam\
		--with-perl --enable-thread-safety LDFLAGS="-lstdc++ -L/usr/local/lib"
	make check: all tests passed
	
	-postgis-1.1.1 -compiles fine, loading 3D polygon fails again,  
geomfromEWKT() does not exist.

Furthermore, I am getting the "could not create shared memory  
segment" Error message, which I didn't get at all when I compiled  
postgresql earlier on. What is worrying me, is that the it is  
actually the very same setup, but things don't work anymore.
I would be very very grateful for any pointers/fixes or fixes or any  
how-to's.

Thanks a lot in advance,
Christian