[postgis-users] Problems adding postgis raster data to db

[Pierre Racine]

What if you tile the raster using the -k 100x100 -I options of raster2pgsql? Same problem?

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of dany_x at inwind.it
> Sent: Tuesday, October 04, 2011 7:30 AM
> To: postgis-users at postgis.refractions.net
> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users