Hey, I encountered countinuous trouble with raster regarding gdal. Only working solution for me was to update it. Also, maybe you could write raster2pgsql -s 31467 -I -C -M /disk1/samba/importdb/dgm_25.t if -t 100x100 rast.dgm25 | to disk, so to see what it says, then try to manually execute it in psql to see if error or notice arise.
Cheers, Rémi-C 2014-03-19 14:19 GMT+01:00 Andreas Laggner <[email protected]>: > Hi list, > > i have some problems with raster datasets since i use postgis 2.1.1 and > postgres 9.3.3 > "POSTGIS="2.1.1 r12113" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March > 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8" > LIBJSON="UNKNOWN" TOPOLOGY RASTER" > > First all my rasters were empty after restoring my dump from 2.03/9.1, > that was no fun, but i still have the files on my harddrive, so i imported > them again: > raster2pgsql -s 31467 -I -C -M /disk1/samba/importdb/dgm_25.tif -t > 100x100 rast.dgm25 | psql -d gis > > All seemed to be good, but as i want to use the raster, all my results > were empty. > > All my imported rasters are empty! Trying to convert the raster to > Polygons returns "No pixels found for band 1" > > The raster files are the same that i imported two months ago to 2.03/9.1, > the raster2pgsql-command is the same too. > > Thanks, Cheers, > > Andreas > > -- > Dipl. Geoökologe Andreas Laggner > > Thünen-Institut für Agrarklimaschutz (AK) > Arbeitsgruppe Emissionsinventare > Johann Heinrich von Thünen-Institut (vTI), > Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei > > Thünen Institute of Climate-Smart Agriculture > Johann Heinrich von Thünen Institute (vTI), > Federal Research Institute for Rural Areas, Forestry and Fisheries > > Bundesallee 50 > D-38116 Braunschweig > > Tel.: (+49) (0)531 596 2636 > Fax : (+49) (0)531 596 2645 > E-mail: [email protected] > Homepage: http://www.ti.bund.de > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
