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, [email protected] 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: [email protected]
Data: 05/10/2011 17.58
A:<[email protected]>
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: [email protected] [mailto:postgis-users-
[email protected]] On Behalf Of [email protected]
Sent: Tuesday, October 04, 2011 7:30 AM
To: [email protected]
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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
