[postgis-users] R: RE: Problems adding postgis raster data to db

[Pierre Racine]

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: dany_x at inwind.it [mailto:dany_x at inwind.it]
> Sent: Wednesday, October 05, 2011 3:24 AM
> To: dany_x at inwind.it; 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: dany_x at inwind.it
> >Data: 04/10/2011 19.37
> >A: <Pierre.Racine at sbf.ulaval.ca>, "PostGIS Users Discussion"<postgis-
> users at postgis.refractions.net>
> >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: Pierre.Racine at sbf.ulaval.ca
> >>Data: 04/10/2011 18.52
> >>A: "dany_x at inwind.it"<dany_x at inwind.it>, "PostGIS Users
> >>Discussion"<postgis-
> >users at postgis.refractions.net>
> >>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: 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 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: Pierre.Racine at sbf.ulaval.ca
> >>> >Data: 04/10/2011 18.39
> >>> >A: "dany_x at inwind.it"<dany_x at inwind.it>, "PostGIS Users
> >>> >Discussion"<postgis-
> >>> users at postgis.refractions.net>
> >>> >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: 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 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: Pierre.Racine at sbf.ulaval.ca
> >>> >> >Data: 04/10/2011 17.07
> >>> >> >A: "dany_x at inwind.it"<dany_x at inwind.it>, "PostGIS Users
> >>> >> >Discussion"<postgis-
> >>> >> users at postgis.refractions.net>
> >>> >> >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: 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
> >>> >
> >>>
> >>>
> >>> _______________________________________________
> >>> 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
> >
>