[postgis-users] Problem with WKTRaster: cannot get raster type in database

[William Kyngesburye]

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-bounces at postgis.refractions.net [mailto:postgis-users-
>> bounces at postgis.refractions.net] On Behalf Of AJ7
>> Sent: 11 mars 2011 11:23
>> To: postgis-users at 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-bounces at postgis.refractions.net [mailto:postgis-users-
>>>> bounces at postgis.refractions.net] On Behalf Of AJ7
>>>> Sent: 11 mars 2011 11:17
>>>> To: postgis-users at 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-bounces at postgis.refractions.net
>> [mailto:postgis-users-
>>>>>> bounces at postgis.refractions.net] On Behalf Of AJ7
>>>>>> Sent: 11 mars 2011 07:02
>>>>>> To: postgis-users at 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 at postgis.refractions.net
>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>> _______________________________________________
>>>>> postgis-users mailing list
>>>>> postgis-users at 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 at postgis.refractions.net
>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at 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 at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at 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