and I have still the same problem. For your information, I'm running GDAL on windows with a PostGIS 2.0 connection on Linux server. I tried many version of GDAL 1.9 and I always have the same problem. The version 1.8 is working very well but I would like to take advantage of the improvements in the last version because I'm working on an important project in Canada where processing time is very important.
> Date: Wed, 16 May 2012 07:38:30 -0700
> Subject: Re: [gdal-dev] GDAL 1.9 and PostGis raster
> From: bkpark <at> ucdavis.edu
> To: belanger_david <at> live.ca
>
> David,
>
> The PostGIS Raster driver in GDAL was and still is in a state of flux.
> GDAL 1.9 should be better than 1.8 as there were significant changes
> to PostGIS Raster before 2.0 and 2.0. You may want to try GDAL trunk.
>
> -bborie
>
> On Tue, May 15, 2012 at 6:37 PM, David B�langer <belanger_david <at> live.ca> wrote:
> > Hi,
> >
> > I stored DEM raster data in PostGIS 2.0 and I used gdal_translate (with
> > mode=2) to extract a mosaic of tiles. When I’m using GDAL 1.8 is working but
> > when I’m using GDAL 1.9 I can see the values of pixel for just one tile.
> >
> >
> >
> > For example I uploaded in the database a tile with an attribute
> > filename=056n05_w and an other tile with an filename=056n05_e and I executed
> > the command with GDAL 1.8 and GDAL 1.9:
> >
> > gdal_translate" -a_nodata "-32767" -of GTIFF "PG:host=myhost port=14070
> > dbname='mybd' user='myuser' password='mypassword' schema='myschema'
> > table='Elevation' mode=2 where=\"filename LIKE \'%056n05%\'\" " 056N05.tif
> >
> >
> >
> > With GDAL 1.8 I obtained a mosaic of 2 tiles (the result expected) but with
> > GDAL 1.9, I obtained a raster with the same extent but only the values of
> > the tile 056n05_w are present. The pixels of the tile 056n05_w have a value
> > 0.
> >
> >
> >
> > Does anyone know this problem and can you help me?
> >
> >
> >
> > Thanks
> >
> > David
> >
> >
> > _______________________________________________
> > gdal-dev mailing list
> > gdal-dev <at> lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
>
>
> --
> Bborie Park
> Programmer
> Center for Vectorborne Diseases
> UC Davis
> 530-752-8380
> bkpark <at> ucdavis.edu