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

dany_x at inwind.it dany_x at inwind.it
Tue Oct 4 04:30:28 PDT 2011


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



More information about the postgis-users mailing list