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

Fri Mar 11 09:05:10 PST 2011

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

Is there a way that I can change $libdir to point to /usr/local/pgsql/lib
instead of /usr/local/pgsql-9.0/lib?

Pierre,
I don't have the libgdal.so

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.