I have been stuck by this problem for a long time. Several ways have already been tried, but none of them works as I was expecting. Here are the description of each of these method as well as the problem I am facing.
I want to know which is the best option to follow on because I am getting confused now.
Method 1: (GDAL + OpenLayers.Layer.Image);
Convert the PostGIS raster to a tif file first using gdal_translate, and then translate this tif file to image (PNG) file. (Because it is faster than convert it directly from PostGIS to PNG).
Then, load this image to Openlayers.
Problems: Don't know how to make it colorful. Because the default iamge is in gray color. Don't know how to add a color table to this.
Method 2: (MapServer + OpenLayers.Layer.WMS): Already get it work in a visual server with 2GB ram. But the problem is the speed. It takes long time to load the data on the map compared with load it as a image file.
Is that the problem with our virtual server or how the way we set up the MapServer?
Method 3: GeoServer + Openlayers.Layer.WMS:
Cannot get it work yet. Because I don't know how to connect it with PostGIS raster. On the previous Post, it seems we have to connect it to JDBC. But I didn't know someone has ever made it work or not.
Waiting for the help. Thanks.