Adding a configuration keyword to the geodatabase in PostgreSQL for the Reviewer workspace

Available with Data Reviewer license.

After data files have been created, the DBTUNE table needs to be updated to include a new configuration keyword. The configuration keyword specifies the table spaces that store the data for the Reviewer workspace. Follow the steps below to add a new configuration keyword to the DBTUNE table.

1. Export the DBTUNE table before making any modifications.
   1. Start ArcCatalog.

      Tip:

      You can also export using ArcMap.

   2. Click the ArcToolbox button on the Standard toolbar.
   3. Expand Data Management Tools > Geodatabase Administration.
   4. Double-click Export Geodatabase Configuration Keywords.

      The Export Geodatabase Configuration Keywords dialog box appears.

   5. Click the browse button for the Input Database Connection parameter and browse to the connection file for the enterprise, workgroup, or desktop geodatabase you want to export.
   6. Click the browse button for the Output File parameter and browse to the path you want to export the file to.
   7. Name the file dbtune_exp.txt and click Save.
   8. Click OK on the Export Geodatabase Configuration Keywords dialog box.
2. Make a copy of dbtune_exp.txt and name the file dbtune_rev.txt.
3. Using a file-based editor, modify the DBTUNE ##DEFAULTS configuration keywords to specify the tablespaces to create the tables and indexes in.

   Note:

   If your database only stores the Reviewer repository, the dbtune_rev.txt file can be opened in a text editor and manually edited; otherwise, create a new configuration keyword (##REVIEWER) using the following DBTUNE ##DEFAULTS example.

   Use the following example to modify the DBTUNE ##DEFAULTS.

   Note:

   Copying and pasting the example may cause syntax errors.

   dbtune_rev.txt
   
   ##DATA_DICTIONARY
   B_INDEX_ROWID   "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE
   rev_sde_dict_index"
   B_INDEX_USER   "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE
   rev_sde_dict_index" 
   B_STORAGE   "TABLESPACE rev_sde_dict"
   MVTABLES_MODIFIED_INDEX   "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE
   rev_sde_dict_index"
   MVTABLES_MODIFIED_TABLE   "TABLESPACE rev_sde_dict"
   STATE_LINEAGES_INDEX   "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE
   rev_sde_dict_index"
   STATE_LINEAGES_TABLE   "TABLESPACE rev_sde_dict"
   STATES_INDEX   "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE
   rev_sde_dict_index"
   STATES_TABLE   "TABLESPACE rev_sde_dict"
   VERSIONS_INDEX   "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE 
   rev_sde_dict_index"
   VERSIONS_TABLE   "TABLESPACE rev_sde_dict"
   XML_INDEX_TAGS_TABLE   "TABLESPACE rev_sde_dict"
   XML_INDEX_TAGS_INDEX   "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE
   rev_sde_dict_index"
   END
   
   ##DEFAULTS
   GEOMETRY_STORAGE   "ST_GEOMETRY"
   RASTER_STORAGE   "BINARY"
   UI_TEXT   "User Interface text for DEFAULTS"
   A_INDEX_ROWID   "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE rev_Aindex"
   A_INDEX_STATEID   "WITH (FILLFACTOR = 75) TABLESPACE rev_Aindex"
   A_INDEX_USER   "WITH (FILLFACTOR = 75) TABLESPACE rev_Aindex"
   A_INDEX_XML   "WITH (FILLFACTOR = 75) TABLESPACE rev_Aindex"
   A_INDEX_RASTER   "WITH (FILLFACTOR = 75) TABLESPACE rev_Aindex"
   A_STORAGE   "TABLESPACE rev_Adata"
   B_INDEX_ROWID   "WITH (FILLFACTOR = 75) TABLESPACE rev_Bindex"
   B_INDEX_STATEID   "WITH (FILLFACTOR = 75) TABLESPACE rev_Bindex"
   B_INDEX_USER   "WITH (FILLFACTOR = 75) TABLESPACE rev_Bindex"
   B_INDEX_XML   "WITH (FILLFACTOR = 75) TABLESPACE rev_Bindex"
   B_INDEX_RASTER   "WITH (FILLFACTOR = 75) TABLESPACE rev_Bindex"
   B_INDEX_TO_DATE   "WITH (FILLFACTOR = 75) TABLESPACE rev_Bindex"
   B_STORAGE   "TABLESPACE rev_Bdata"
   D_INDEX_ALL   "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE rev_Dindex"
   D_INDEX_DELETED_AT   "WITH (FILLFACTOR = 75) TABLESPACE rev_Dindex"
   D_STORAGE   "TABLESPACE rev_Ddata"
   RAS_STORAGE   "TABLESPACE rev_Bdata"
   RAS_INDEX_ID   "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE rev_Bindex"
   BND_STORAGE   "TABLESPACE rev_Bdata"
   BND_INDEX_ID   "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE rev_Bindex"
   BND_INDEX_COMPOSITE   "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE rev_Bindex"
   AUX_STORAGE   "TABLESPACE rev_Bdata"
   AUX_INDEX_COMPOSITE   "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE rev_Bindex"
   BLK_STORAGE   "TABLESPACE rev_Bdata"
   BLK_INDEX_COMPOSITE   "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE rev_Bindex"
   XML_DOC_INDEX   "WITH (FILLFACTOR = 90) USING INDEX TABLESPACE rev_Bindex"
   XML_DOC_STORAGE   "TABLESPACE rev_Bdata"
   #XML_DOC_UNCOMPRESSED_TYPE   "BINARY"
   XML_IDX_INDEX_DOUBLE   "WITH (FILLFACTOR = 75) TABLESPACE rev_Bindex"
   XML_IDX_INDEX_ID   "WITH (FILLFACTOR = 75) TABLESPACE rev_Bindex"
   XML_IDX_INDEX_PK   "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE rev_Bindex"
   XML_IDX_INDEX_STRING   "WITH (FILLFACTOR = 75) TABLESPACE rev_Bindex"
   XML_IDX_INDEX_TAG   "WITH (FILLFACTOR = 75) TABLESPACE rev_Bindex"
   XML_IDX_STORAGE   "TABLESPACE rev_Bindex"
   XML_IDX_FULLTEXT_UPDATE_METHOD   "AUTOMATIC"
   #XML_COLUMN_STORAGE		- "SDE_XML" or "DB_XML"
   XML_COLUMN_STORAGE   "DB_XML"
   END
   ##PG_GEOMETRY
   GEOMETRY_STORAGE   "PG_GEOMETRY"
   UI_TEXT   "User Interface text description"
   END
   

4. Import the modified dbtune_rev.txt file using ArcCatalog or ArcMap.
   1. In the ArcToolbox window, expand Data Management Tools > Geodatabase Administration.
   2. Double-click Import Geodatabase Configuration Keywords.

      The Import Geodatabase Configuration Keywords dialog box appears.

   3. Click the browse button next to the Input Database Connection parameter, and browse to the path where the file will be imported.
   4. Click the browse button for the Input File parameter, and browse to the path where the file will be imported.
   5. Name the file dbtune_rev.txt, and click Open.
   6. Click OK on the Import Geodatabase Configuration Keywords dialog box.