Maintenance outage for upgrade on Sunday, September 22

This site, docs.bmc.com, will be inaccessible for two hours starting at 8 AM CDT, Sunday, September 22, for a platform upgrade.

Page tree

Maintenance outage for upgrade on Sunday, September 22

This site, docs.bmc.com, will be inaccessible for two hours starting at 8 AM CDT, Sunday, September 22, for a platform upgrade.

Skip to end of metadata
Go to start of metadata

To ensure the availability and integrity of your data, you must periodically back up the database files for the TrueSight Presentation Server. BMC recommends that you use a storage replication solution to back up the database and configuration files at regular intervals. 

This topic contains the following information:

Backup frequency

The state of the recovery TrueSight Presentation Server depends on how recently you backed up your files. According to your organization's IT policies, you can decide whether to have daily, weekly, or monthly backups.

By default, the Presentation Server automatically performs a database backup every 24 hours.

Manually creating a backup of the database

Note

Ensure that the database service is running before you create a manual backup of the database.

Run the following command from the <Presentation Server installation directory>\truesightpserver\bin folder:

tssh database startbackup

A backup of the database is created in the <Presentation Server installation directory>\truesightpserver\data\dbbackup folder.

Changing the automatic database backup settings

The following table lists the default automatic database backup settings. To change a setting, run the appropriate command from the <Presentation Server installation directory>\truesightpserver\bin folder.

ParameterDefault settingCommand to change setting
Backup time3.30 AM (Presentation Server timezone)

tssh database change -h <hours> -m <minutes>

Example: tssh database change -h 22 -m 30

Backup frequencyEvery 24 hours

tssh database change -i <frequency interval>

Example: tssh database change -i 12

Number of backups retainedThe latest three backups

tssh database change -n <number of backups to retain>

Example: tssh database change -n 2

Restoring a backup of the database

  1. Stop the Presentation Server service by running the following command from the <Presentation Server installation directory>\truesightpserver\bin folder:
    tssh server stop 
  2. Move the files in the <Presentation Server installation directory>\truesightpserver\data\pgsql folder to a temporary folder.
  3. Extract the contents of the database backup file in the <Presentation Server installation directory>\truesightpserver\data\dbbackup folder to the the <Presentation Server installation directory>\truesightpserver\data\pgsql folder.
  4. Restart the Presentation Server service by running the following command from the <Presentation Server installation directory>\truesightpserver\bin folder:
    tssh server start
  5. If you encounter any issues after restoring a backup of the database, use the files that you moved to a temporary folder in Step 2.

Note

On Linux computers, add & at the end of the tssh server start command so that the process runs in the background and you can continue to use the shell.

Note

When you restore the database, some VM instances or devices are marked for deletion.

Related topics

Setting up and managing the App Visibility components and databases


Configuring and managing the Presentation Server


4 Comments

  1. Hello Team,

    We cannot find the KA426529 mentioned in the above document link.

    Requesting to please update the hyperlink or provide the correct KA details. Also is the KA applicable for version 10.7 and later ?

    Thanks

    Harshal

    1.  

      1.  

        1.