I made a ticket for it so we might have a look at it later: http://trac.osgeo.org/postgis/ticket/1239
Pierre > -----Original Message----- > From: [email protected] [mailto:postgis-users- > [email protected]] On Behalf Of Mathieu Basille > Sent: Thursday, October 06, 2011 5:44 PM > To: [email protected] > Subject: Re: [postgis-users] Problems adding postgis raster data to db > > Short answer is: it only happens on Linux. I discussed it today with Pierre > Racine, > and he might have a look at it (differences between Windows and Linux > versions) if he finds time for it. The main problem is that we cannot use > raster2pgsql in a script, since it would require a manual intervention... > > Mathieu. > > > Le 06/10/2011 03:15, [email protected] a écrit : > > > > Thank you very much.... you made my day, i was stuck in that point for > > about 2 days now. > > Why this isn't mentioned in none manual or guide whatever?!?!?!? > > Thank you again > > Daniele > > > >> ----Messaggio originale---- > >> Da: [email protected] > >> Data: 05/10/2011 17.58 > >> A:<[email protected]> > >> Ogg: Re: [postgis-users] Problems adding postgis raster data to db > >> > >> If I'm not mistaken, I would suggest you type 'q' to quit the message. > >> The (END) is a sign that it is indeed a message... Try it, and you > >> should see a lot of 'INSERT 0 1' appearing. > >> > >> Hope this helps, > >> M > >> > >> > >> Le 2011-10-04 11:07, Pierre Racine a écrit : > >>> 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 > >> > >> -- > >> > >> ~$ whoami > >> Mathieu Basille, Post-Doc > >> > >> ~$ locate > >> Laboratoire d'Écologie Comportementale et de Conservation de la Faune > >> + Centre d'Étude de la Forêt > >> Département de Biologie > >> Université Laval, Québec > >> > >> ~$ info > >> http://ase-research.org/basille > >> > >> ~$ fortune > >> ``If you can't win by reason, go for volume.'' > >> Calvin, by Bill Watterson. > >> _______________________________________________ > >> 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 > > -- > > ~$ whoami > Mathieu Basille, Post-Doc > > ~$ locate > Laboratoire d'Écologie Comportementale et de Conservation de la Faune > + Centre d'Étude de la Forêt > Département de Biologie > Université Laval, Québec > > ~$ info > http://ase-research.org/basille > > ~$ fortune > ``If you can't win by reason, go for volume.'' > Calvin, by Bill Watterson. > _______________________________________________ > 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
