[postgis-users] Problems adding postgis raster data to db

[Mathieu Basille]

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.