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

AJ7 ackbar at ackadij.com
Fri Mar 11 11:11:16 PST 2011


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-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
> 
> 
> _______________________________________________
> 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-tp31124425p31127898.html
Sent from the PostGIS - User mailing list archive at Nabble.com.




More information about the postgis-users mailing list