Installing the ST_Raster type in a local PostgreSQL database

If the ArcSDE command line tools 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 either the ArcSDE application server for PostgreSQL and command line tools or the stand-alone command line tools.

   This installation can be downloaded from the Esri Customer Care Portal.

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.
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 want to create only 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