[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 robe):

 I just tried using gdal_translate (packaged with 6.5dev from here
 http://www.gisinternals.com/sdk/)
 (http://www.gisinternals.com/sdk/PackageList.aspx?file=release-1600-gdal-
 mapserver.zip)  which should be in theory similar command as what
 Mapserver uses for loading postgis raster

 {{{
 gdal_translate -of jpeg PG:"host='localhost' port='5432'
 dbname='somedb' user='postgres' password='whatever' schema='aerials'
 table='o_2_boston' where='filename=\'22528915.sid.jpg\' ' mode='2'"
 c:\test.jpg
 }}}

 and this worked fine on PostGIS 2.1.3, PostgreSQL 9.2 database.  So maybe
 something with mapserver then.  Will take me longer to set that up, but at
 least doesn't seem anything wrong with latest gdal (and I'm pretty sure
 I've used similar older gdal to do those exports).  Can you if not too
 much trouble turn logging on your database and include output of query
 mapserver is running.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2986#comment:8>
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.