no problem loading shapefile. This is a problem i have on work, tomorrow in the morning i will post more logs. Thanky you very much.
>----Messaggio originale---- >Da: [email protected] >Data: 04/10/2011 18.52 >A: "[email protected]"<[email protected]>, "PostGIS Users Discussion"<postgis- [email protected]> >Ogg: RE: [postgis-users] R: RE: R: RE: Problems adding postgis raster data to db > >Loading a shapefile works fine? Any more informative log? > >> -----Original Message----- >> From: [email protected] [mailto:postgis-users- >> [email protected]] On Behalf Of [email protected] >> Sent: Tuesday, October 04, 2011 12:50 PM >> To: PostGIS Users Discussion >> Subject: [postgis-users] R: RE: R: RE: Problems adding postgis raster data to db >> >> 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 > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
