<div dir="ltr">If your restored raster data was in-db, it would have nothing to do with GDAL. GDAL only kicks in when accessing out-db raster, polygonization and warping...<div><br></div><div>Are you able to post the output of ST_Metadata() and ST_BandMetadata() for one of the rasters in the database that returning no values?</div>
<div><br></div><div>-bborie</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Mar 19, 2014 at 9:02 AM, Andreas Laggner <span dir="ltr"><<a href="mailto:andreas.laggner@ti.bund.de" target="_blank">andreas.laggner@ti.bund.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Everything was ok, no errors and no warnings, like it is when i import raster now. But there are no pixel values!!<br>
<br>
I think it has something to do with my PostGIS installation and gdal....<br>
<br>
<br>
<br>
<br>
Am 19.03.2014 16:50, schrieb Bborie Park:<div class="HOEnZb"><div class="h5"><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
What was the output when restoring your backup? And what was your restore<br>
command?<br>
<br>
I've never had problems dumping and restoring in my production environments.<br>
<br>
-bborie<br>
<br>
<br>
On Wed, Mar 19, 2014 at 6:19 AM, Andreas Laggner <<a href="mailto:andreas.laggner@ti.bund.de" target="_blank">andreas.laggner@ti.bund.de</a><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
wrote:<br>
Hi list,<br>
<br>
i have some problems with raster datasets since i use postgis 2.1.1 and<br>
postgres 9.3.3<br>
"POSTGIS="2.1.1 r12113" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March<br>
2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8"<br>
LIBJSON="UNKNOWN" TOPOLOGY RASTER"<br>
<br>
First all my rasters were empty after restoring my dump from 2.03/9.1,<br>
that was no fun, but i still have the files on my harddrive, so i imported<br>
them again:<br>
raster2pgsql -s 31467 -I -C -M /disk1/samba/importdb/dgm_25.<u></u>tif -t<br>
100x100 rast.dgm25 | psql -d gis<br>
<br>
All seemed to be good, but as i want to use the raster, all my results<br>
were empty.<br>
<br>
All my imported rasters are empty! Trying to convert the raster to<br>
Polygons returns "No pixels found for band 1"<br>
<br>
The raster files are the same that i imported two months ago to 2.03/9.1,<br>
the raster2pgsql-command is the same too.<br>
<br>
Thanks, Cheers,<br>
<br>
Andreas<br>
<br>
--<br>
Dipl. Geoökologe Andreas Laggner<br>
<br>
Thünen-Institut für Agrarklimaschutz (AK)<br>
Arbeitsgruppe Emissionsinventare<br>
Johann Heinrich von Thünen-Institut (vTI),<br>
Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei<br>
<br>
Thünen Institute of Climate-Smart Agriculture<br>
Johann Heinrich von Thünen Institute (vTI),<br>
Federal Research Institute for Rural Areas, Forestry and Fisheries<br>
<br>
Bundesallee 50<br>
D-38116 Braunschweig<br>
<br>
Tel.: <a href="tel:%28%2B49%29%20%280%29531%20596%202636" value="+495315962636" target="_blank">(+49) (0)531 596 2636</a><br>
Fax : <a href="tel:%28%2B49%29%20%280%29531%20596%202645" value="+495315962645" target="_blank">(+49) (0)531 596 2645</a><br>
E-mail: <a href="mailto:andreas.laggner@ti.bund.de" target="_blank">andreas.laggner@ti.bund.de</a><br>
Homepage: <a href="http://www.ti.bund.de" target="_blank">http://www.ti.bund.de</a><br>
<br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
<br>
</blockquote></blockquote>
<br>
-- <br>
Dipl. Geoökologe Andreas Laggner<br>
<br>
Thünen-Institut für Agrarklimaschutz (AK)<br>
Arbeitsgruppe Emissionsinventare<br>
Johann Heinrich von Thünen-Institut (vTI),<br>
Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei<br>
<br>
Thünen Institute of Climate-Smart Agriculture<br>
Johann Heinrich von Thünen Institute (vTI),<br>
Federal Research Institute for Rural Areas, Forestry and Fisheries<br>
<br>
Bundesallee 50<br>
D-38116 Braunschweig<br>
<br>
Tel.: <a href="tel:%28%2B49%29%20%280%29531%20596%202636" value="+495315962636" target="_blank">(+49) (0)531 596 2636</a><br>
Fax : <a href="tel:%28%2B49%29%20%280%29531%20596%202645" value="+495315962645" target="_blank">(+49) (0)531 596 2645</a><br>
E-mail: <a href="mailto:andreas.laggner@ti.bund.de" target="_blank">andreas.laggner@ti.bund.de</a><br>
Homepage: <a href="http://www.ti.bund.de" target="_blank">http://www.ti.bund.de</a><br>
<br>
</div></div></blockquote></div><br></div>