I have GDAL 1.9.1 in QGIS and 1.9.0 in PostGIS. I will try latest version later, I need to finish my work and have last few days - no time for testing :) But I hope that it will resolve my issue. Maybe this ticket has something common with this issue http://trac.osgeo.org/gdal/ticket/4678.
Jakub 2012/8/23 Bborie Park <bkp...@ucdavis.edu> > What version of GDAL are you using? There was a fix for the GDAL driver > in GDAL -trunk that resolved issues I was having with in QGIS display. > > If you've compiled your own GDAL, I do recommend running GDAL trunk for > all the fixes. > > -bborie > > On 08/23/2012 09:03 AM, Jakub Hettler wrote: > > Hi all, > > I have a weird problem with PostGIS raster and I think GDAL driver > > > > I upload my image into database with > > > > raster2pgsql -C -N -e -Y -F -s 4326 -t 256x256 -l 2,4 myRaster | psql -d > > test -U postgres > > > > My original image is here > > > https://skydrive.live.com/?cid=a61d00de178d6e45&id=A61D00DE178D6E45%21311&sff=1 > > > > everything is ok now, but I would like to see my image in QGIS or use > > gdal_translate and there is a problem I expect the same, because QGIS > uses > > gdal_translate. > > > > with gdal_translate as gdal_translate -of PNG "PG:host=localhost > > dbname='test' user='postgres' password=''pass' schema='public' > > table=prehl500_zr mode=2" C:\users\jakub\desktop\somefile.png > > > > I get this > > > https://skydrive.live.com/?cid=a61d00de178d6e45&id=A61D00DE178D6E45%21312&sff=1 > > > > There are some missing tiles, but I said ok, there are some empty data in > > my database. > > > > I try to use large objects to export one of the missing tiles directly > from > > DB > > > > SELECT oid, lowrite(lo_open(oid, 131072), png) As num_bytes > > FROM > > ( VALUES (lo_create(0), > > ST_AsPNG( (select rast from prehl500_zr where rid in (14)) ) > > ) ) As v(oid,png); > > > > and then in psql > > > > \lo_export 165836 testX.png -- the number 165836 is oid return by the > first > > select > > > > and everything is ok I get the image one of the missing one in my picture > > over gdal_translate. > > > > Do you have some ideas where is the problem me, GDAL, PostGIS? > > > > Thanks > > > > Jakub > > > > > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > -- > Bborie Park > Programmer > Center for Vectorborne Diseases > UC Davis > 530-752-8380 > bkp...@ucdavis.edu > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
