Installing the ST_Raster type in a local PostgreSQL database

If ArcSDE and PostgreSQL are installed on the same server, follow these steps to create the ST_Raster type in the database and configure access to it:

Steps:

1. Install ArcSDE for PostgreSQL.
2. If you are installing on a Linux server, copy the libst_raster_pg shared library from the SDEHOME/lib directory to the PostgreSQL lib > pgsql directory.

   When installing on a local Windows server, the installation wizard automatically copies the libst_raster_pg library to the PostgreSQL folder.

3. Run the sdesetup command with the install_st_raster operation.

   sdesetup -o install_st_raster -d POSTGRESQL
   -D pgdb -s server2 -u sde
   
   Please enter ArcSDE DBA password:
   

4. Using the PostgreSQL pgAdmin III application, connect as any user and test the installation of the ST_Raster type by executing the following SELECT statement:

   SELECT st_raster_check_compatibility();

   The statement should return "Compatible".

5. Either create an ST_RASTER configuration keyword in the sde_dbtune table with a RASTER_STORAGE parameter set to ST_RASTER or set the RASTER_STORAGE parameter under the DEFAULTS keyword to ST_RASTER.
   • If you want most or all of your raster data to be created using the ST_Raster type when using ArcGIS software, set the RASTER_STORAGE parameter value under the DEFAULTS keyword to ST_RASTER.

     sdedbtune -o alter -k DEFAULTS -P RASTER_STORAGE
     -v ST_RASTER -i sde:postgresql -D rasterdb -s server2 -u sde

   • If you only want to create some raster data with ST_Raster storage, add a keyword—ST_RASTER—to your sde_dbtune table and include the RASTER_STORAGE parameter set to ST_RASTER and the UI_TEXT parameter.

     sdedbtune -o insert -k ST_RASTER -P RASTER_STORAGE 
     -v ST_RASTER -i sde:postgresql -D rasterdb -s server2 -u sde
     
      sdedbtune -o insert -k ST_RASTER -P UI_TEXT -v UI_TEXT 
     -i sde:postgresql -D rasterdb -s server2 -u sde