Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have the following requirements to manage raster data

1) Convert raster-maps from BSB format to PNG or GeoTIFF
2) Cut the borders of the map
3) Merge individual maps to form a contiguous coverage map
4) Tile them for caching and loading
5) Serve them up on a WMS service to clients.

I am using OpenLayers->GeoServer->PostGIS stack to manage all my vector data. I have been thinking of loading, storing & retrieve raster data the same way (in PostGIS).

So my questions are

1) What is the benefit of storing rasters in DB over doing this in the file system?
2) What are the steps to achieve this and what tools/ commands I would use?
3) Would I leverage the DB cache or would I still need a tile-cache ?
4) What are the bugs/ gotchas in PostGIS raster handling that I need to watch out for?


share|improve this question
Please focus on only one question per thread. – R.K. Nov 3 '12 at 5:00
up vote 2 down vote accepted

I don't think PostGIS will gain you much for your stated requirements. The value in PostGIS for raster is that you can do PostGIS processing (using the Raster functions that are provided). If you don't need that processing, then it will probably be easier to just use GeoServer to serve up your maps.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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