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
