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

William Kyngesburye woklist at kyngchaos.com
Fri Mar 11 09:37:13 PST 2011 

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-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
>> 
>> _______________________________________________
>> 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-tp31124425p31126877.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

-----
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

More information about the postgis-users mailing list