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

[dany_x at inwind.it]

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
>