[postgis-users] postgis raster export problem in using gdal_translate

[mahavir trivedi]

On Tue, Mar 27, 2012 at 7:10 PM, Pierre Racine
<Pierre.Racine at sbf.ulaval.ca>wrote:

> Please send the complete raster2pgsql and gdal_translate command you used.
>
> Pierre
>
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net [mailto:
> postgis-users-
> > bounces at postgis.refractions.net] On Behalf Of mahavir trivedi
> > Sent: Tuesday, March 27, 2012 4:28 AM
> > To: postgis-users at postgis.refractions.net
> > 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120328/24fe124e/attachment.html>
-------------- next part --------------
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