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
      

Related Topics

6/19/2015