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

[dany_x at inwind.it]

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
>