Thank you very much.... you made my day, i was stuck in that point for about 2 days now. Why this isn't mentioned in none manual or guide whatever?!?!?!? Thank you again Daniele
>----Messaggio originale---- >Da: [email protected] >Data: 05/10/2011 17.58 >A: <[email protected]> >Ogg: Re: [postgis-users] Problems adding postgis raster data to db > >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: [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 > >-- > >~$ 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 >[email protected] >http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
