Installing the ST_Raster type in a remote PostgreSQL database

If ArcSDE 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. Log in to the PostgreSQL remote host machine.
  2. If PostgreSQL is installed on an operating system (OS) that is different than the OS of your ArcSDE server, install ArcSDE for PostgreSQL on the PostgreSQL server to obtain the correct libst_raster_pg library for the PostgreSQL server OS.
  3. Copy the libst_raster_pg library from SDEHOME > bin to the PostgreSQL lib > pgsql directory.
  4. If you installed ArcSDE on the PostgreSQL server, uninstall it.
  5. Log in to the ArcSDE server.
  6. 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:
    
  7. 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".

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

2/5/2013