No table was added by the process. if i try to close the Terminal it says that there's a process still running but with the command top i can't see it using cpu
>----Messaggio originale---- >Da: [email protected] >Data: 04/10/2011 18.39 >A: "[email protected]"<[email protected]>, "PostGIS Users Discussion"<postgis- [email protected]> >Ogg: RE: [postgis-users] R: RE: Problems adding postgis raster data to db > >Even if the cursor is still flashing, did you check if the table was well created? > >> -----Original Message----- >> From: [email protected] [mailto:postgis-users- >> [email protected]] On Behalf Of [email protected] >> Sent: Tuesday, October 04, 2011 12:36 PM >> To: PostGIS Users Discussion >> Subject: [postgis-users] R: RE: Problems adding postgis raster data to db >> >> Thank you for the answer. I already created the .sql file with -k 50x50 -I options. >> >> >----Messaggio originale---- >> >Da: [email protected] >> >Data: 04/10/2011 17.07 >> >A: "[email protected]"<[email protected]>, "PostGIS Users >> >Discussion"<postgis- >> [email protected]> >> >Ogg: RE: [postgis-users] Problems adding postgis raster data to db >> > >> >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 > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
