Moving TSI Data

Moving TSI Data

To transfer data from one TSI to another, you need to do the following:

  1. In the old TSI VM shell:

    cd /home/apache

    pg_dumpall -U postgres -c > tactic_database.sql

  2. In your host machine assuming windows, start a new window of Windows Explorer in the address, type in:

    \\<your old VM IP address>

    when prompted for uid, password, type in :

    apache

    south123paw

    navigate into the apache folder, you should see the file tactic_database.sql, assets folder and projects folder

  3. You need to move the old TSI's tactic_database.sql, assets folder and projects folder to the same location of the TSI you just downloaded and installed.

    Same as above, open a new windows explorer, but type in the new TSI IP address and carry out the copying

  4. In the new TSI VM shell, assuming you have copied the tactic_database.sql, assets folder and projects folder in the new IP from the TSI, Type in:

    dropdb -U postgres sthpw

    psql -U postgres < tactic_database.sql

  5. Upgrade the TACTIC database in the TSI according to the version you are upgrading to

  6. Now you can just shut down the old TSI by closing the VMware player window