Restore the Postgres DSC Repository: Command Line | Teradata DSA - 17.20 - Restoring the Postgres DSC Reporitory When Any or Old Bootstrap File is Available: Command Line - BAR - Data Stream Architecture

Teradata® DSA User Guide

Data Stream Architecture
Release Number
Release Date
October 2021
Content Type
User Guide
Publication ID
English (United States)
  1. Copy the bootstrap_<backupID>.out into the landing zone and run the following commands.
    (default is: /var/opt/teradata/dsa/postgres)
  2. Navigate to /opt/teradata/client/17.06/dsa/dsc: cd $DSA_DSC_ROOT
  3. User:
    su dscuser
  4. Restore the repository:
    sh -m recovery
  5. Check the list of backup IDs available on the replication target group:
    sh -m list_backupids -r replicating_target_group
  6. Get the bar_<backupID>.out from replication target group:
    sh -m replicate_from -v <backupID> -r <replicationTargetGroupName>
    For example, sh -m replicate_from -v 1602081495349 -r TGP
  7. Check the replication status:
    sh -m save_sets_replication_status
  8. Restore the backup:
    sh -m restore -v <backupID>
    For example, sh -m restore -v 1602081495349
  9. Exit dscuser:
  10. Restart DSC:
    /etc/init.d/dsc restart