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.
| Parameter | Default setting | Command to change setting |
|---|---|---|
| Backup time | 3.30 AM (Presentation Server timezone) |
Example: |
| Backup frequency | Every 24 hours |
Example: |
| Number of backups retained | The latest three backups |
Example: |
Restoring a backup of the database
- Stop the Presentation Server service by running the following command from the <Presentation Server installation directory>\truesightpserver\bin folder:
tssh server stop - Move the files in the <Presentation Server installation directory>\truesightpserver\data\pgsql folder to a temporary folder.
- 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.
- Restart the Presentation Server service by running the following command from the <Presentation Server installation directory>\truesightpserver\bin folder:
tssh server start - 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 a disaster-recovery system for Presentation Server
Overview
Content Tools
Apps
Reporter Replacement
com.bmc.atlassian.bmc-util-plugin-2.section.label
Tasks