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

[Mathieu Basille]

Short answer is: it only happens on Linux. I discussed it today with 
Pierre Racine, and he might have a look at it (differences between 
Windows and Linux versions) if he finds time for it. The main problem is 
that we cannot use raster2pgsql in a script, since it would require a 
manual intervention...

Mathieu.


Le 06/10/2011 03:15, dany_x at inwind.it a écrit :
>
> 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
>>
>
>
> _______________________________________________
> 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.