LAYER
    NAME test
    TYPE raster
    STATUS ON
    DATA "PG:host=website.com port=1234
          dbname='raster_dev' user='username' password='password'
          schema='public' table='rasters_outdb' where=''rid'=1'"
    PROJECTION
        "init=epsg:3310"
    END
    PROCESSING "NODATA=252"
    PROCESSING "RESAMPLE=NEAREST"
END

msDrawMap(): Image handling error. Failed to draw layer named 'test'. drawGDAL(): Unable to access file. GDALDatasetRasterIO() failed: IReadBlock failed at X offset 0, Y offset 0

LAYER
    NAME test
    TYPE raster
    STATUS ON
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=website.com port=1234 user=username dbname=raster_dev password=password"

    # Turn on Mapserver Connection pool for performance
    # http://blog.cleverelephant.ca/2008/10/mapserverpostgis-performance-tips.html
    PROCESSING "CLOSE_CONNECTION=DEFER"

    DATA "SELECT table.rgb_bytes FROM table WHERE table.id=1 and  ST_Intersects(table.geom, !BOX!)"
    PROJECTION
        "init=epsg:3310"
    END
    PROCESSING "NODATA=252"
    PROCESSING "RESAMPLE=NEAREST"
END

LAYER
    NAME tindex_layer
    TYPE vector
    STATUS OFF
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=website.com port=1234 user=username dbname=raster_dev password=password"
    PROCESSING "CLOSE_CONNECTION=DEFER"

    DATA "geom FROM (SELECT geom,id,location FROM table WHERE ST_Intersects(geom, !BOX!) AS subquery USING UNIQUE id USING SRID=4326
END

LAYER
    NAME raster_layer
    TYPE raster
    STATUS ON
    TILEINDEX tindex_layer
END