Installing the ST_Raster type in a remote PostgreSQL database

If the ArcSDE command line tools and PostgreSQL are installed on different servers, follow these instructions 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 on the remote computer.

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

  2. Log in to the PostgreSQL remote host machine.
  3. Copy the libst_raster_pg library from SDEHOME > bin to the PostgreSQL lib > pgsql directory.

    Be sure to copy the libst_raster_pg library specific to the operating system of your PostgreSQL server: libst_raster_pg.dll is for Windows, libst_raster_pg.so is for Linux.

  4. Log in to the server where the ArcSDE command line tools are installed.
  5. 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:
    
  6. 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."

  7. 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