[postgis-tickets] [PostGIS] #2986: [raster] raster2pgqsql

[PostGIS]

#2986: [raster] raster2pgqsql
-------------------------+--------------------------------------------------
 Reporter:  rmorelli     |       Owner:  dustymugs    
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.1.5
Component:  raster       |     Version:  2.1.x        
 Keywords:               |  
-------------------------+--------------------------------------------------

Comment(by rmorelli):

 I gave the relevat output of mapserver error log above, BTW here is the
 complete capture with log level set to 5
 {{{
 [Mon Nov 10 16:48:41 2014].280037 msDrawMap(): rendering using
 outputformat named png (AGG/PNG).
 [Mon Nov 10 16:48:41 2014].280097 msDrawMap(): WMS/WFS set-up and query,
 0.000s
 [Mon Nov 10 16:48:41 2014].280122 msDrawRasterLayerLow(dem20): entering.
 [Mon Nov 10 16:48:41 2014].298835 msDrawRasterLayerLow(): Unable to access
 file. Corrupt, empty or missing file 'PG:host=localhost port=5432
 dbname='xxx' user=xxx password=xxx schema='raster' table='dem'
 where='filename='dem20_1.tif'' mode='2'' for layer 'dem20'. Error browsing
 database for PostGIS Raster properties
 [Mon Nov 10 16:48:41 2014].298861 msDrawMap(): Image handling error.
 Failed to draw layer named 'dem20'.
 [Mon Nov 10 16:48:41 2014].299182 msFreeMap(): freeing map at 0x1b06a80
 }}}

 This is the output when running gdal_translate as you did:

 {{{
 gdal_translate -of jpeg PG:"host='localhost' port='5432' dbname='xxx'
 user='xxx' password='xxx' schema='raster' table='dem'
 where='filename='dem20_1.tif'' mode='2' " test.jpg
 Warning 1: Cannot find information about raster.dem table in
 raster_columns view. The raster table loading would take a lot of time.
 Please, execute AddRasterConstraints PostGIS function to register this
 table as raster table in raster_columns view. This will save loading time.
 ERROR 1: Error browsing database for PostGIS Raster properties
 GDALOpen failed - 1
 Error browsing database for PostGIS Raster properties
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2986#comment:9>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.