Thank you for the answer. I already created the .sql file with -k 50x50 -I options.
>----Messaggio originale---- >Da: [email protected] >Data: 04/10/2011 17.07 >A: "[email protected]"<[email protected]>, "PostGIS Users Discussion"<postgis- [email protected]> >Ogg: RE: [postgis-users] Problems adding postgis raster data to db > >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
