This may have been asked before, but A) what software/libraries etc do I need to B) load multiple rasters into PostGIS?

I have Python 2.7.5, QGIS 1.9 (latest Weekly Build), PostGIS (whatever the latest version is) and I've downloaded the latest batch of GDAL codecs)

Any help would be greatly appreciated



  • equally I keep seeing lots of pages saying to use raster2pgsql - but do I run this Command Prompt, in Python, in QGIS? (I've tried all three so far with no success!) – SteveC81 Aug 8 '13 at 20:23
  • gis.stackexchange.com/questions/65848/… you run the command in postgres pgadminIII or for windows the command prompt logged into postgres – Mapperz Aug 8 '13 at 20:26
  • Is that in the PSQL Console in pgAdminIII? – SteveC81 Aug 8 '13 at 20:31
  • yes the PSQL Console in pgAdminIII under Plugins – Mapperz Aug 8 '13 at 20:40
  • 1
    You use the -f option, which specifies the name of the destination raster column, but you don't specify a name. Like this, raster2pgsql will set "-I" as column name instead of interpreting -I as an option. See postgis.refractions.net/docs/using_raster.xml.html for more info. I assume that you separated the two commands (raster2pgsql, psql) by a semicolon. Consider piping them (using the | character) instead of saving the commands to a .sql each time. – xandriksson Aug 9 '13 at 7:50

I managed to get it to work - I needed to add the folder where the raster2pgsql is located into the environmental variables - Path on the computer. This enabled me to run the application in cmd, although not within pgAdminIII for some reason...

| improve this answer | |
  • Could you mark this as the answer, so it gets "closed off". Thanks – BradHards Oct 10 '13 at 2:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.