[postgis-users] Help urgently needed - geomfromEWKT() / PostGIS on Mac OS X
Benoit Ogier
benoit.ogier at cbconseil.com
Thu Feb 9 06:06:53 PST 2006
Hi,
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
00800000030000000100000006403D365F202107B8C05442226809D49540240000000000
00403D3612839042D9C054422A0EC743204024000000000000403D35FF822BBECBC05442
2235B4EDB34024000000000000403D36262CBA732EC05441F0DC768DFC40240000000000
00403D366BC621B7E1C05441F312B1B36C4024000000000000403D365F202107B8C05442
226809D4954024000000000000
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
I succeed with :
- Complete clean of postgres/postgis/geos/proj4 stuff
- Install Geos-2.2.1
./configure
make
sudo make install
- Install Proj-4.4.9
./configure
make
sudo make install
- 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
make
sudo make install
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
- Install Postgis 1.1.1
./configure --with-pgsql="/usr/local/bin/pg_config" --with-geos="/usr/
local/bin/geos-config" --with-proj="/usr/local/"
make
sudo make install
With previous versions of postgis, i just had to make and install.
Yesterday, I loose hours to understand why ./configure returns some
errors (Postgres not found). Any idea about these ./configure problems ?
B. Ogier
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
};
--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060209/50532588/attachment.html>
More information about the postgis-users
mailing list