[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