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

[Pierre Racine]

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