[postgis-tickets] [PostGIS] #2203: [raster]: Can't read out_db jpg in some cases

[PostGIS]

#2203: [raster]: Can't read out_db jpg in some cases
---------------------+------------------------------------------------------
  Reporter:  robe    |       Owner:  dustymugs    
      Type:  defect  |      Status:  assigned     
  Priority:  medium  |   Milestone:  PostGIS 2.1.0
 Component:  raster  |     Version:  trunk        
Resolution:          |    Keywords:  history      
---------------------+------------------------------------------------------

Comment(by robe):

 dustymugs,

 Windows uses the internal libjpeg.

 I'm pretty sure you are right about permissions now.  That I think solves
 the mystery about why the raster2pgsql loader (when loading in db) works
 fine on this image with my windows 7 but fails on my windows 2008.  I
 remembered that my windows 7 doesn't have all that UAC crap enabled on it
 so when I run raster2pgsql on my windows 7, I'm running under my full
 administrative powers.  On the windows 2008, even though I was logged in
 as administrator, raster2pgsql failed to work to load the image in the db
 -- HOWEVER, if I right-click on the batch script I have and choose -- "Run
 as administrator"  it works fine.

 Now why the postgres outdb doesn't work I assume is probably a similar
 issue, but I would have expected it to work on my windows 7.  When I run
 in windows 7 for development, I'm not running with an installed postgresql
 instance, but one I launch with a batch script that runs under my local
 admin account.  I don't think I even have a postgres account on my window
 7 or postgresql installed at all. So in theory it should have full rights
 to do damage to my whole system.  So maybe there are other measures
 embedded in postgres that prevent from writting to the root drive.

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