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

[dany_x at inwind.it]

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
>