On Tue, Mar 27, 2012 at 7:10 PM, Pierre Racine <[email protected]>wrote:
> Please send the complete raster2pgsql and gdal_translate command you used. > > Pierre > > > -----Original Message----- > > From: [email protected] [mailto: > postgis-users- > > [email protected]] On Behalf Of mahavir trivedi > > Sent: Tuesday, March 27, 2012 4:28 AM > > To: [email protected] > > Subject: [postgis-users] postgis raster export problem in using > gdal_translate > > > > dear > > > > > > i have 7053x6078 pixel georeferrance tiff image. > > > > it is import using raster2pgsql ok > > > > but export it using gdal_translate command output is uncleard(Strange) > not as > > original input. my out put format is same Tiff input > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
raster2pgsql -s 4236 -I -C -M BAND2.tif -F -t 100x100 public.demelevation > elev.sql psql -d gisdb -f elev.sql gdal_translate -of GTiff PG:"host=localhost dbname=gisdb user=postgres password=postgres123 table=band mode=2" D:\test.tif -------------------------------------------------------------------------------------------------------------------------------------- Configuration detail postgis 2.0 gdl core 1.9 RAM 4 GB if i set shared_buffer set to more than 1 GB then postgressqlserver will not started. work_mem= 2000MB checkpoint_segment= 20 image raster size : 94 MB 7053x6067 pixel ----------------------------------------------------------------------------------------------------------------------------------------- Problem output is not same as input means output image disorted
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
