Hi William, sorry for the late reply. Actually no I have no problems with postgis - also, there was no postgres version error.
I ended up modifying my rtpostgis.sql file and substituting the $libdir with the actual path of where the rtpostgis.so was found, and this worked fine. William Kyngesburye wrote: > > Just trying to figure out where the problem is happening (internally) - > did the error have the postgres version in the error message for the path > to rtpostgis.sql? > > Are you having any problems with PostGIS? PostGIS and WKTraster are build > exactly the same way and the SQL setup operates the same ($libdir/...). > > On Mar 11, 2011, at 1:11 PM, AJ7 wrote: > >> >> sorry - meant to add that the command didn't work (got the same errors) >> >> >> William Kyngesburye wrote: >>> >>> On Mar 11, 2011, at 11:05 AM, AJ7 wrote: >>> >>>> >>>> Hi William, >>>> I also think it might be a linking or not finding path issue. When I >>>> remove >>>> the $libdir in rtpostgis.sql and put the full path where the >>>> rtpostgis.so >>>> is, it seems to want to do it, but i didnt want to substitute all... >>>> >>> Try running the psql command as I specified below - does that work? >>> >>>> Is there a way that I can change $libdir to point to >>>> /usr/local/pgsql/lib >>>> instead of /usr/local/pgsql-9.0/lib? >>>> >>> That should not be necessary. >>> >>>> Pierre, >>>> I don't have the libgdal.so >>>> >>> And you shouldn't. >>> >>>> >>>> >>>> William Kyngesburye wrote: >>>>> >>>>> GDAL shouldn't be the problem. This is OS X, and GDAL is a framework, >>>>> so >>>>> you won't see a library file in Postgres lib/ or /usr/local/lib. >>>>> rtpostgis.so is properly linked to the GDAL framework. >>>>> >>>>> It looks to me like it's /usr/local/pgsql but can't handle the symlink >>>>> to >>>>> /usr/local/pgsql-9.0. Or it doesn't like the mismatch? What about >>>>> this: >>>>> >>>>> su - postgres -c '/usr/local/pgsql-9.0/bin/psql -p 5433 -d [dbname] -f >>>>> /usr/local/pgsql-9.0/share/contrib/rtpostgis.sql' >>>>> >>>>> On Mar 11, 2011, at 10:35 AM, Pierre Racine wrote: >>>>> >>>>>> Well I can't open those .dmg files. The only important thing is that >>>>>> the >>>>>> gdal library is beside the rtpostgis.so library and is named >>>>>> libgdal.so >>>>>> >>>>>> Do you have that? >>>>>> >>>>>>> -----Original Message----- >>>>>>> From: postgis-users-boun...@postgis.refractions.net >>>>>>> [mailto:postgis-users- >>>>>>> boun...@postgis.refractions.net] On Behalf Of AJ7 >>>>>>> Sent: 11 mars 2011 11:23 >>>>>>> To: postgis-users@postgis.refractions.net >>>>>>> Subject: Re: [postgis-users] Problem with WKTRaster: cannot get >>>>>>> raster >>>>>>> type in database >>>>>>> >>>>>>> >>>>>>> Hi Pierre >>>>>>> I installed from here:http://www.kyngchaos.com/software/postgres >>>>>>> >>>>>>> I already had GDAL 1.8 complete installed on my machine, so didn't >>>>>>> bother >>>>>>> installing again. (all the installations from the link above worked >>>>>>> fine). >>>>>>> >>>>>>> >>>>>>> >>>>>>> Pierre Racine-2 wrote: >>>>>>>> >>>>>>>> Is there any way I can see the list of file included in your >>>>>>>> kyngchaos >>>>>>>> package? >>>>>>>> >>>>>>>> libgdal is the base GDAL library. rtpostgis.so is dependent on it >>>>>>>> and >>>>>>>> should be able to find it in the same folder or any lib search >>>>>>>> folder. >>>>>>>> >>>>>>>> Pierre >>>>>>>> >>>>>>>>> -----Original Message----- >>>>>>>>> From: postgis-users-boun...@postgis.refractions.net >>>>>>>>> [mailto:postgis-users- >>>>>>>>> boun...@postgis.refractions.net] On Behalf Of AJ7 >>>>>>>>> Sent: 11 mars 2011 11:17 >>>>>>>>> To: postgis-users@postgis.refractions.net >>>>>>>>> Subject: Re: [postgis-users] Problem with WKTRaster: cannot get >>>>>>>>> raster >>>>>>> type in database >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> Yes I do have the rtpostgis.so file in "usr/local/pgsql-9.0/lib", >>>>>>>>> but >>>>>>>>> I >>>>>>>>> don't have any libgdal. where should I get this from? Is this why >>>>>>>>> its >>>>>>>>> not >>>>>>>>> working? >>>>>>>>> >>>>>>>>> >>>>>>>>> Pierre Racine-2 wrote: >>>>>>>>>> >>>>>>>>>> Do you have the "rtpostgis" shared library in >>>>>>>>>> "usr/local/pgsql-9.0/lib"? >>>>>>>>>> There should be "libgdal" as well. >>>>>>>>>> >>>>>>>>>> Pierre >>>>>>>>>> >>>>>>>>>>> -----Original Message----- >>>>>>>>>>> From: postgis-users-boun...@postgis.refractions.net >>>>>>> [mailto:postgis-users- >>>>>>>>>>> boun...@postgis.refractions.net] On Behalf Of AJ7 >>>>>>>>>>> Sent: 11 mars 2011 07:02 >>>>>>>>>>> To: postgis-users@postgis.refractions.net >>>>>>>>>>> Subject: [postgis-users] Problem with WKTRaster: cannot get >>>>>>>>>>> raster >>>>>>>>>>> type >>>>>>> in >>>>>>>>> database >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> Hi, >>>>>>>>>>> I installed postgis1.5 and the corresponding wkt package for the >>>>>>>>>>> Mac >>>>>>>>>>> OS >>>>>>>>>>> Leopard 1.6...using the packages from kyngchaos. While I believe >>>>>>>>>>> that >>>>>>>>>>> wktraster has been installed properly (i.e. i could run the >>>>>>>>>>> gdal2wktraster.py script on a tiff file), when I try to enable >>>>>>>>>>> my >>>>>>> database >>>>>>>>>>> for the raster type support, this is not working. I get the >>>>>>>>>>> error: >>>>>>>>>>> psql:/usr/local/pgsql/share/contrib/rtpostgis.sql:32: ERROR: >>>>>>>>>>> could >>>>>>>>>>> not >>>>>>>>>>> access file "$libdir/rtpostgis": No such file or directory >>>>>>>>>>> psql:/usr/local/pgsql/share/contrib/rtpostgis.sql:37: ERROR: >>>>>>>>>>> type >>>>>>> raster >>>>>>>>>>> does not exist >>>>>>>>>>> psql:/usr/local/pgsql/share/contrib/rtpostgis.sql:45: ERROR: >>>>>>>>>>> function >>>>>>>>>>> raster_in(cstring) does not exist >>>>>>>>>>> psql:/usr/local/pgsql/share/contrib/rtpostgis.sql:58: ERROR: >>>>>>>>>>> could >>>>>>>>>>> not >>>>>>>>>>> access file "$libdir/rtpostgis": No such file or directory >>>>>>>>>>> >>>>>>>>>>> I am try the following command: >>>>>>>>>>> su - postgres -c '/usr/local/pgsql-9.0/bin/psql -p 5433 -d >>>>>>>>>>> [dbname] >>>>>>>>>>> -f >>>>>>>>>>> /usr/local/pgsql/share/contrib/rtpostgis.sql' >>>>>>>>>>> >>>>>>>>>>> what is wrong here please? >>>>>>>>>>> pg_config --libdir -> usr/local/pgsql-9.0/lib >>>>>>>>>>> pg_config --pkglibdir -> usr/local/pgsql-9.0/lib >>>>>>>>>>> >>>>>>>>>>> really need help on this.Hope its a simple thing. >>>>>>>>>>> thanks >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> View this message in context: >>>>>>>>> http://old.nabble.com/Problem-with-WKTRaster%3A-cannot-get-raster-type- >>>>>>>>>>> in-database-tp31124425p31124425.html >>>>>>>>>>> Sent from the PostGIS - User mailing list archive at Nabble.com. >>>>>>>>>>> >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> postgis-users mailing list >>>>>>>>>>> postgis-users@postgis.refractions.net >>>>>>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>>>>>>>> _______________________________________________ >>>>>>>>>> postgis-users mailing list >>>>>>>>>> postgis-users@postgis.refractions.net >>>>>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> View this message in context: >>>>>>> http://old.nabble.com/Problem-with-WKTRaster%3A-cannot-get-raster-type- >>>>>>>>> in-database-tp31124425p31126445.html >>>>>>>>> Sent from the PostGIS - User mailing list archive at Nabble.com. >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> postgis-users mailing list >>>>>>>>> postgis-users@postgis.refractions.net >>>>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>>>>>> _______________________________________________ >>>>>>>> postgis-users mailing list >>>>>>>> postgis-users@postgis.refractions.net >>>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> -- >>>>>>> View this message in context: >>>>>>> http://old.nabble.com/Problem-with-WKTRaster%3A-cannot-get-raster-type- >>>>>>> in-database-tp31124425p31126499.html >>>>>>> Sent from the PostGIS - User mailing list archive at Nabble.com. >>>>>>> >>>>>>> _______________________________________________ >>>>>>> postgis-users mailing list >>>>>>> postgis-users@postgis.refractions.net >>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>>>> _______________________________________________ >>>>>> postgis-users mailing list >>>>>> postgis-users@postgis.refractions.net >>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>>> >>>>> ----- >>>>> William Kyngesburye <kyngchaos*at*kyngchaos*dot*com> >>>>> http://www.kyngchaos.com/ >>>>> >>>>> "We are at war with them. Neither in hatred nor revenge and with no >>>>> particular pleasure I shall kill every ___ I can until the war is >>>>> over. >>>>> That is my duty." >>>>> >>>>> "Don't you even hate 'em?" >>>>> >>>>> "What good would it do if I did? If all the many millions of people of >>>>> the >>>>> allied nations devoted an entire year exclusively to hating the ____ >>>>> it >>>>> wouldn't kill one ___ nor shorten the war one day." >>>>> >>>>> <Ha, ha> "And it might give 'em all stomach ulcers." >>>>> >>>>> - Tarzan, on war >>>>> >>>>> _______________________________________________ >>>>> postgis-users mailing list >>>>> postgis-users@postgis.refractions.net >>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>>> >>>>> >>>> >>>> -- >>>> View this message in context: >>>> http://old.nabble.com/Problem-with-WKTRaster%3A-cannot-get-raster-type-in-database-tp31124425p31126877.html >>>> Sent from the PostGIS - User mailing list archive at Nabble.com. >>>> >>>> _______________________________________________ >>>> postgis-users mailing list >>>> postgis-users@postgis.refractions.net >>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>> >>> ----- >>> William Kyngesburye <kyngchaos*at*kyngchaos*dot*com> >>> http://www.kyngchaos.com/ >>> >>> "Those people who most want to rule people are, ipso-facto, those least >>> suited to do it." >>> >>> - A rule of the universe, from the HitchHiker's Guide to the Galaxy >>> >>> >>> _______________________________________________ >>> postgis-users mailing list >>> postgis-users@postgis.refractions.net >>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>> >>> >> >> -- >> View this message in context: >> http://old.nabble.com/Problem-with-WKTRaster%3A-cannot-get-raster-type-in-database-tp31124425p31127898.html >> Sent from the PostGIS - User mailing list archive at Nabble.com. >> >> _______________________________________________ >> postgis-users mailing list >> postgis-users@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users > > ----- > William Kyngesburye <kyngchaos*at*kyngchaos*dot*com> > http://www.kyngchaos.com/ > > [Trillian] What are you supposed to do WITH a maniacally depressed robot? > > [Marvin] You think you have problems? What are you supposed to do if you > ARE a maniacally depressed robot? No, don't try and answer, I'm 50,000 > times more intelligent than you and even I don't know the answer... > > - HitchHiker's Guide to the Galaxy > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- View this message in context: http://old.nabble.com/Problem-with-WKTRaster%3A-cannot-get-raster-type-in-database-tp31124425p31142856.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
