Did you try loading another smaller image? If it works then there might be a problem with your image and you will have an idea of the time required to load your image. It could take a while depending on your hardware. If it doesn't work then we will have a text .sql file small enough so we can examine and debug it.
Pierre > -----Original Message----- > From: [email protected] [mailto:[email protected]] > Sent: Wednesday, October 05, 2011 3:24 AM > To: [email protected]; Pierre Racine; PostGIS Users Discussion > Subject: R: [postgis-users] R: RE: Problems adding postgis raster data to db > > Good Morning, > > this are the commands i give to my bash: > > ..../clip$ python /usr/lib/postgresql/8.4/bin/raster2pgsql.py -r > cliptavag.tif -t > tavag -o tavag.sql -s 32633 -k 50x50 -I > ------------------------------------------------------------ > Summary of GDAL to PostGIS Raster processing: > ------------------------------------------------------------ > Number of processed raster files: 1 (cliptavag.tif) List of generated tables > (number of tiles): > 1 tavag (11088) > > .../clip$ psql -U dermap -d raster -f tavag.sql > > > 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) > > and it's stuck again near (END) for about ten minutes now. > > DC > > >----Messaggio originale---- > >Da: [email protected] > >Data: 04/10/2011 19.37 > >A: <[email protected]>, "PostGIS Users Discussion"<postgis- > [email protected]> > >Ogg: [postgis-users] R: RE: R: RE: R: RE: Problems adding postgis > >raster data > to db > > > > > >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 > > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
