The data I have used is DEM. It creates a table and has 2 columns in PostGIS. Is it necessary to create a new table again and follow the configuration process as mentioned in the Image Mosaic JDBC documentation?

The error -

INFO | jvm 1 | 2016/01/20 19:28:24 | java.lang.RuntimeException: Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/oek.pgraster.xml.xml and hints null INFO | jvm 1 | 2016/01/20 19:28:24 | at org.geoserver.web.data.layer.NewLayerPageProvider.getItemsInternal(NewLayerPageProvider.java:151) INFO | jvm 1 | 2016/01/20 19:28:24 | at org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:59) INFO | jvm 1 | 2016/01/20 19:28:24 | at org.geoserver.web.wicket.GeoServerDataProvider.fullSize(GeoServerDataProvider.java:242) INFO | jvm 1 | 2016/01/20 19:28:24 | at ......

Removed rest of redundant log entries...

  • Good question, I also had to face, but what's the use of PostGIS to store these rasters, while GeoServer can directy access raster files to create services ? I don't know if storing rasters on PGis is the best way for Services. We can :<br/> - use PostGis to store rasters, and then query Z info from a (X,Y) point with SQL query<br/> OR<br/> - use GeoServer and rasters from a directory to create services such as WMS – Daemons Jan 20 '16 at 13:39
  • To store large amount of data each time we would have to copy the data to the server. But with postgis as the database it would be easier to access in the long run. That's y. We can do queries from Geoserver directly from here – Bharat Bittu Jan 20 '16 at 14:11
  • What exactly are you trying to do/having problems with? – MaryBeth Jan 20 '16 at 14:46
  • I'm loading rasters to PostGIS using raster2pgsql. To load these rasters to Geoserver from PostGIS we need to follow these steps. After following these steps, I'm still not able to load it in Geoserver. Is their any simpler method ? – Bharat Bittu Jan 20 '16 at 14:56

Setting up geoserver to use postgis raster is not an easy job. Also, you have to rethink the reason why you are using postgis raster to store your rasters. Postgis does NOT make access to your raster faster or easier (actually, it makes it slower). It would't help you much in the administration of files, since you have to script that anyway and geoserver doesn't allow for much administration of these rasters either. The only good reason I can imagine to use postgis raster would be because you are doing a lot of analysis in combination with vectors that are also in postgis and you want to serve the (raster) results of this analysis as soon as possible via geoserver.

With that out of the way:
Postgis raster cannot be directly opened from geoserver but requires the image mosaic plugin After installing this plugin you can use this tutorial to apply a bunch of settings manually. But beware, you are entering rather uncharted area.

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.