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
