Running PostgreSQL CustomDBViews in a sharded deployment

Procedure

  1. Run all the scripts within each directory for each shard: <INSTALL_DIR>/database/postgresql/scripts/CustomDBViews/<tabletype>

    Here, <tabletype> refers to configuration, transaction, and master.

  2. Run the configuration table type scripts for the Configuration shard, the transaction table type scripts for the Transaction shard, and the master table type scripts for the Master shard.
  3. For a sharded deployment, run yfs_addnl_index.sql in <INSTALL_DIR>/database/postgresql/scripts/CustomDBIndexes/<tabletype>

    Here, <tabletype> refers to configuration and transaction.

    Note: When you manually run the custom view scripts, ignore the wms_master_db_script.sql script.