[postgis-users] rasters not read

[Jorge Arévalo]

On Tue, Jan 4, 2011 at 3:07 PM, Paolo Cavallini <cavallini at faunalia.it> wrote:
> Hi all.
> I updated PostGIS from trunk yesterday, and I now get errors reading
> rasters from newly created db:
>
> gdal_translate -of GTiff "PG: dbname=test3 host=fox user=test
> password=*** port=5432 schema=public
> table=spain_images" /home/paolo/Desktop/spain.tif
> ERROR 1: Can't get georeference coordinates from database
> ord=test port=5432 schema=public
> table=spain_images" /home/paolo/Scrivania/prov.ERROR 1: Sorry, but
> couldn't create the structure to read the             raster on memory,
> aborting.
> GDALOpen failed - 1
> Sorry, but couldn't create the structure to read the             raster
> on memory, aborting.
>
> Any hint?
> All the best.
> --
> http://www.faunalia.it/pc
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

Hi Paolo,

This is a problem with GDAL driver, not a PostGIS one. I need to know 2 things:

- What version of GDAL are you using? (gdalinfo --version)
- Did you specify the srid when you loaded the raster files? Using -s
option in raster2pgsql.py (or gdal2wktraster.py, in case of and old
version of PostGIS Raster)

Best regards,

-- 
Jorge Arévalo
Internet & Mobilty Division, DEIMOS
jorge.arevalo at deimos-space.com
http://mobility.grupodeimos.com/
http://gis4free.wordpress.com
http://geohash.org/ezjqgrgzz0g