[postgis-devel] raster2pgsql error?

Salvatore Larosa-1 s_larosa at libero.it
Wed Mar 7 10:12:10 PST 2012


Hi,
I'm trying to import a tif raster [1] into PostGIS but I have a problem!

raster2pgsql command seems to run correctly, 
but when I try to display the raster in qgis my map is empty!

below what i do:

1] postgres at debian:~$ raster2pgsql -s 4236 -I -C -M
/home/sam/pgraster_test/katrina.tif -F -t 64x64 public.katrina >
/home/sam/pgraster_test/katrina.sql 

2] postgres at debian:~$ psql -f /home/sam/pgraster_test/katrina.sql -d
workshop

in QGIS:

>>> from qgis.utils import iface
>>> connection = "PG:host='localhost' port='5432' dbname='workshop'
>>> user='postgres' password='*******' schema='public' table='katrina'
>>> mode='2'"
>>> iface.addRasterLayer(connection, "katrina")

Any hint?


[1] - http://dl.dropbox.com/u/6599273/katrina.tif



--
View this message in context: http://postgis.17.n6.nabble.com/raster2pgsql-error-tp4555617p4555617.html
Sent from the PostGIS - Dev mailing list archive at Nabble.com.



More information about the postgis-devel mailing list