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
