[postgis-users] Problems adding postgis raster data to db

[Pierre Racine]

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: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Mathieu Basille
> Sent: Thursday, October 06, 2011 5:44 PM
> To: postgis-users at postgis.refractions.net
> 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, dany_x at inwind.it 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: basille at ase-research.org
> >> Data: 05/10/2011 17.58
> >> A:<postgis-users at postgis.refractions.net>
> >> 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: postgis-users-bounces at postgis.refractions.net
> >>>> [mailto:postgis-users- bounces at postgis.refractions.net] On Behalf
> >>>> Of dany_x at inwind.it
> >>>> Sent: Tuesday, October 04, 2011 7:30 AM
> >>>> To: postgis-users at postgis.refractions.net
> >>>> 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
> >>>> postgis-users at postgis.refractions.net
> >>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>> _______________________________________________
> >>> postgis-users mailing list
> >>> postgis-users at postgis.refractions.net
> >>> 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
> >> postgis-users at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users