What if you tile the raster using the -k 100x100 -I options of raster2pgsql? Same problem?
> -----Original Message----- > From: [email protected] [mailto:postgis-users- > [email protected]] On Behalf Of [email protected] > Sent: Tuesday, October 04, 2011 7:30 AM > To: [email protected] > Subject: [postgis-users] Problems adding postgis raster data to db > > Hi everyone, > i have problems executing the .sql file i created with raster2pgsql to my > postgres9.0-postgis2.0 db. > The creation of the .sql from a .tiff went trought without a problem, but > when i > try the simple command psql -U user -d db -f raster.sql all i receive is > addrastercolumn > > -------------------------------------------------------------------------------------------------- > -------------------------------------------------------------------------------------------------- > -------------------------------------------------------------------------------------------------- > -------------------------------------------------------------------------------------------------- > ----------- > public.tavag.rast srid:32633 pixel_types:{16BUI,16BUI,16BUI} out_db:false > regular_blocking:true nodata_values:'{65535,65535,65535}' scale_x:'0.4999569' > scale_y:'-0.49995690000006' blocksize_x:'50' blocksize_y:'50' extent:POLYGON > ((360718.287740393 5106518.39173093,360718.287740393 > 5108308.73738983,364560.956473793 5108308.73738983,364560.956473793 > 5106518.39173093,360718.287740393 5106518.39173093)) > (1 row) > > (END) > > with the cursor flashing near the (END).... i've tried waiting 30 and more > minutes, but nothing. > The .tiff file is 170mb and the .sql 390mb. > > Any ideas? > > Thank you, > DC > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
