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

Related Topics


11/18/2013