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
