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

[Kirk R. Wythers]

On Feb 9, 2006, at 7:52 AM, Christian Heine wrote:

> Mark & list,
> On Thu, 9 Feb 2006, Mark Cave-Ayland wrote:
> [snip]
>>> 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.
>> Hi Christian,
>>
>> First of all, we'd need a lot more information about how you are  
>> installing
>> PostgreSQL/PostGIS in order to be able to help. In particular,  
>> we'd need
>> more information about the commands you used after ./configure  
>> (did you use
>> make or make install?)
> Used following sequnence of commands:
> ./configure
> make
> sudo make install
> [postgresql: make check]
>
>> how you executed initdb
> [as postgresql user] initidb -D /Volumes/Data/geodatabase
>
>> and the commands you used to
>> start and stop the PostgreSQL server (so we can see that you are  
>> trying to
>> connect to the version you have just compiled).
> [as postgresql user] pg_ctl -D /Volumes/Data/geodatabase -l logfile  
> start
> [as postgresql user] pg_ctl stop
>
>> Plus the *exact* command you
>> are using to try and insert your EWKT geometry rather a cut down  
>> version
>> would be a lot more useful.
> (Taken from E. Cordery's message, 04.Feb 2005, this list)
>
> BEGIN TRANSACTION;
> create table polygon3d (id int4);
> select addgeometrycolumn('polygon3d','shape',-1,'POLYGON',3);
>
> insert into polygon3d (id,shape) values (1, 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));
>
> insert into polygon3d (id,shape) values (2, geomfromEWKT('POLYGON 
> ((29.214342
> -81.036386 30, 29.210082 -81.034641 30, 29.213140 -81.036927 30,  
> 29.214342
> -81.036386 30))',-1));
>
> insert into polygon3d (id,shape) values (3, geomfromEWKT('POLYGON 
> ((29.214427
> -81.033325 20,29.209782 -81.031445 20, 29.209739 -81.031199  
> 20,29.210286
> -81.029269 20,29.210383 -81.029404 20 , 29.214427 -81.033325  
> 20))',-1));
> commit;
>
> Other try, inserting into an existing db table:
>
> BEGIN TRANSACTION;
> INSERT INTO srtmtiles (tile_name, comment, tile_outline)
> 	VALUES('W180N90', 'christian, 04-10-2005', GeomFromEWKT('POLYGON 
> ((-180 90, -140 90, -140 40, -180 40, -180 90))', 4326));
>
> [sequence of comparable insert statements with different polygons]
>
> COMMIT;
>
> As I wrote, most of the sql scripts have been working absolutley  
> flawlessly until I updated (and likely stuffed up) my database. I  
> had written small how-to when I did the first install, so I  
> followed it step by step for this one.
>
>> I'd be inclined to go for option 1) in your attempt to get everything
>> working, as newer software tends to have less bugs, and I seem to  
>> remember
>> several Xcode related fixes have been added recently.
>
> I absolutely agree - and this was of course my intention to  
> upgrade. I expected it to be a lot more smooth, but given the  
> messages in the www there seem to be a fair bit of people having  
> trouble to install Postgresql from src on Mac OS X 10.4.x.
>
>> Without having more information as to all the commands you have  
>> typed, I'd
>> say it sounds as if you've either mixed up different versions of
>> PostgreSQL/PostGIS or your database cluster is somehow corrupted.
>
> Well, as I wrote, I did a clean install - nothing more on the  
> machine than the geos & proj libs, postgresql and postgis and a  
> (working) version of readline through fink. The DB cluster should  
> be fine (as the postgresql checks revealed) as it was just  
> initialised.
>
> Cheers,
> Christian
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Christian,

I have postgres 8.1, postgis 1.1.1 and grass (all compiled from src)  
running on my dual G5. If you send me a series of commands (starting  
with an a test data base) I will try them on my machine.

Kirk


Kirk R. Wythers, Research Fellow
Dept. of Forest Resources
University of Minnesota
1530 Cleveland Ave N
Saint Paul, MN 55108
tel: 612.625.2261
email: kwythers at umn.edu