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

William Kyngesburye woklist at kyngchaos.com
Fri Mar 11 12:52:19 PST 2011 

Just trying to figure out where the problem is happening (internally) - did the error have the postgres version in the error message for the path to rtpostgis.sql?

Are you having any problems with PostGIS?  PostGIS and WKTraster are build exactly the same way and the SQL setup operates the same ($libdir/...).

On Mar 11, 2011, at 1:11 PM, AJ7 wrote:

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

[Trillian]  What are you supposed to do WITH a maniacally depressed robot?

[Marvin]  You think you have problems?  What are you supposed to do if you ARE a maniacally depressed robot?  No, don't try and answer, I'm 50,000 times more intelligent than you and even I don't know the answer...

- HitchHiker's Guide to the Galaxy

More information about the postgis-users mailing list