How to load Raster Data in PostGIS

[Stephen Woodbridge]

KS,

You should probably read the PostGIS list archives. This has been 
discussed extensively. The short answer is don't, you can't at this 
point in time. But then I'm not familiar with pgchip, but I suspect that 
that is bleeding edge prototype stuff.

-Steve W

KS wrote:
> Hi,
> 
> I am trying to load raster data into PostGIS and then wants to render it in 
> web browser through mapserver. The porblem is, how to store raster data in 
> PostGIS/Postgres SQL. There are multiple ideas I am working on right now
>  
> 1. Can we store actually raster data direcly in PostgreSQL or PostGIS or we 
> should strore it in outside of PostGIS and have some sort of reference to 
> PostGIS with other data.
> 2. Can we actually use PGCHIP GDAL driver (new implementation of raster in 
> PostGIS). For reference please visit,  http://simon.benjamin.free.fr/pgchip/ ?
> 3. Can we use PGRaster SQL Interface to store raster data 
> (http://postgis.com/support/wiki/index.php?PgRasterSqlInterface). I tried to 
> do it but it did not work. So just wondering if somebody has actually used it to 
> store raster data. If so, then how? 
>  
> If somebody has used some solution to store raster data in PostGIS, please let 
> me know. If this is not possible at all, then may suggest some alternative.
> Here I want to mention that I have data in the form of ESRI shapefiles (mostly 
> vector format). I tried to use gdal_rasterize but it gave me error that "The 
> procedure entry point OGRCleanupALL could not be located in the dynamic link 
> library gdal13.dll". I tried to fix it and tried to re-install GDAL as well but I got 
> same message.
>  
> Regards,