If I'm not mistaken, I would suggest you type 'q' to quit the message. The (END) is a sign that it is indeed a message... Try it, and you should see a lot of 'INSERT 0 1' appearing.
Hope this helps, M Le 2011-10-04 11:07, Pierre Racine a écrit : > What if you tile the raster using the -k 100x100 -I options of raster2pgsql? > Same problem? > >> -----Original Message----- >> From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- >> boun...@postgis.refractions.net] On Behalf Of dan...@inwind.it >> Sent: Tuesday, October 04, 2011 7:30 AM >> To: postgis-users@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@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users -- ~$ whoami Mathieu Basille, Post-Doc ~$ locate Laboratoire d'Écologie Comportementale et de Conservation de la Faune + Centre d'Étude de la Forêt Département de Biologie Université Laval, Québec ~$ info http://ase-research.org/basille ~$ fortune ``If you can't win by reason, go for volume.'' Calvin, by Bill Watterson. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users