0

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

Thanks

Steve

Improve this question
7
  • 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, 2013 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, 2013 at 20:26
  • Is that in the PSQL Console in pgAdminIII?
    – SteveC81
    Aug 8, 2013 at 20:31
  • yes the PSQL Console in pgAdminIII under Plugins
    – Mapperz ♦
    Aug 8, 2013 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, 2013 at 7:50

1 Answer 1

Reset to default
0

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
1
  • Could you mark this as the answer, so it gets "closed off". Thanks
    – BradHards
    Oct 10, 2013 at 2:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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