What happen when you dump only a raster table or schema without using the pg_dump -b option?
Pierre ________________________________________ From: [email protected] [[email protected]] On Behalf Of Bborie Park [[email protected]] Sent: Wednesday, March 19, 2014 12:04 PM To: [email protected] Cc: PostGIS Users Discussion Subject: Re: [postgis-users] no pixels in raster 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... 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? -bborie On Wed, Mar 19, 2014 at 9:02 AM, Andreas Laggner <[email protected]<mailto:[email protected]>> wrote: Everything was ok, no errors and no warnings, like it is when i import raster now. But there are no pixel values!! I think it has something to do with my PostGIS installation and gdal.... Am 19.03.2014 16:50, schrieb Bborie Park: What was the output when restoring your backup? And what was your restore command? I've never had problems dumping and restoring in my production environments. -bborie On Wed, Mar 19, 2014 at 6:19 AM, Andreas Laggner <[email protected]<mailto:[email protected]> wrote: 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<tel:%28%2B49%29%20%280%29531%20596%202636> Fax : (+49) (0)531 596 2645<tel:%28%2B49%29%20%280%29531%20596%202645> E-mail: [email protected]<mailto:[email protected]> Homepage: http://www.ti.bund.de _______________________________________________ postgis-users mailing list [email protected]<mailto:[email protected]> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- 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<tel:%28%2B49%29%20%280%29531%20596%202636> Fax : (+49) (0)531 596 2645<tel:%28%2B49%29%20%280%29531%20596%202645> E-mail: [email protected]<mailto:[email protected]> Homepage: http://www.ti.bund.de _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
