[postgis-users] Problem with WKTRaster: cannot get raster type in database
AJ7
ackbar at ackadij.com
Mon Mar 14 04:02:44 PDT 2011
Hi William,
sorry for the late reply.
Actually no I have no problems with postgis - also, there was no postgres
version error.
I ended up modifying my rtpostgis.sql file and substituting the $libdir with
the actual path of where the rtpostgis.so was found, and this worked fine.
William Kyngesburye wrote:
>
> 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
>
>
> _______________________________________________
> 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-tp31124425p31142856.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
More information about the postgis-users
mailing list