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
