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

Thu Feb 9 06:23:58 PST 2006

Dear Benoit,
thanks for the helopful reply, this might help a lot.

> 1) It seems that geomfromewtk(text,integer) does not exist in function list. 
> You have to use geomfromewtk(text).
> select 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))')
> returns
> 00800000030000000100000006403D365F202107B8C05442226809D4954024000000000000403D3612839042D9C054422A0EC743204024000000000000403D35FF822BBECBC054422235B4EDB34024000000000000403D36262CBA732EC05441F0DC768DFC4024000000000000403D366BC621B7E1C05441F312B1B36C4024000000000000403D365F202107B8C05442226809D4954024000000000000

Ok, this is my fault then.

> 2) Yesterday, I succeed to install postgis 1.1.1 on my iBook after hours of 
> "./configure" errors...
> my config is :
> iBook G4 PPC
> Mac OS 10.4.4
> GCC 4.0.1
> Postgresql 8.1.2
> PostGIS 1.1.1
> GEOS 2.2.1
> Proj 4.4.9

Yes, this is the configuration I was aiming for as well.

>
> I succeed with :
> - Complete clean of postgres/postgis/geos/proj4 stuff
>
> - Install Geos-2.2.1
> ./configure
> make
> sudo make install

Did the same, no errors

> - Install Proj-4.4.9
> ./configure
> make
> sudo make install
Same, also no errors

> - Install Postgres 8.1.2
> 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
I had some trouble using the -multibyte and unicode conversion flags, but 
no errors when running configure. See my original message for my detailed 
configure line. I put the LDFLAGS at the end.

> make
> sudo make install
Same sequence.

> sudo chown -R postgres /usr/local/pgsql/
> su - postgres
> /usr/local/bin/initdb -D /usr/local/pgsql/data
> /usr/local/bin/pg_ctl -D /usr/local/pgsql/data -l 
> /usr/local/pgsql/data/postgres.log start
Yes, same sequence of commands.
>
> - Install Postgis 1.1.1
> ./configure --with-pgsql="/usr/local/bin/pg_config" 
> --with-geos="/usr/local/bin/geos-config" --with-proj="/usr/local/"

The configure script figured out where the geos and prj libraries were 
located in my case, so I didn't put them on the statement, further, I did 
not append the "--with-pgsql" statement. Is this necessary?

> make
> sudo make install
Same for me. At some stage (can't exactly remember the versions) postgis 
complained when I loaded it in the DB using psql mytestdb < lwpostgis.sql
See my libgeom* messages for more details on that issue.

> With previous versions of postgis, i just had to make and install.
Yes, that was with vers. 1.0.0, if I remember correctly.

> Yesterday, 
> I loose hours to understand why ./configure returns some errors (Postgres not 
> found). Any idea about these ./configure problems ?
As I said, ./configure on postgresql did not produce errors when I ran it, 
some warnings yes, but no proper errors. May be it didn't like some of the 
compiler flags you specified, but I am not a specialist... 
unfortunately ;-))

I call it a day now, as it gets late down here in Australia. Will have 
another go tomorrow.

Thanks so far for all the responses. May be the Mac users on this list 
could team up and write a short manual on installing procedures that could 
go into the postgis wiki.

Christian

  Le 9 févr. 06 à 13:59, Christian Heine a écrit :
>
>> 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
>> 
>> 
>> 
>> 
>> 
>> _______________________________________________
>> 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
> };
> -- 
>