Backing up and recovering the App Visibility database

Backing up the App Visibility database

Make a physical backup of the App Visibility PostgreSQL database to protect your data from loss. The output of a physical backup contains the data files that the App Visibility server can use directly, resulting in a faster recovery operation.

To create an App Visibility database backup file

1. On the computer with the App Visibility portal or collector, navigate to the following directory:

   • (Windows) collector_installationDirectory\collector\bin\db or portal_installationDirectory\portal\bin\db
   • (Linux) collector_installationDirectory/collector/bin/db or portal_installationDirectory/portal/bin/db

   If the portal and collector are installed on the same computer, they share a database, and you only need to perform the procedure in one place.
   If the portal and collector are on separate computers, perform the backup procedure on both components at the same time so that the backup content is consistent. Otherwise, the backup content does not match and the data is incorrect when restored.

2. Run the following script:
   
   • (Windows) create-pgsql-dump.bat
   • (Linux) ./create-pgsql-dump.sh

The script creates a backup of the data in the avdb.dump file in the server component's installationDirectory\ADOP_DB\pgsql\backup directory.

For more information about making PostgreSQL database backup files, see Backup and Restore.

Recovering the App Visibility database data

If you have issues with your database, you can recover the backed-up data file.

To recover the backed up App Visibility data file

1. Ensure that the avdb.dump file is in the server component's installationDirectory\ADOP_DB\pgsql\backup directory.

2. Stop the component service:

   • On the computer with the App Visibility portal, stop the portal service.
   • On the computer with the App Visibility collector, stop the collector service.

   For information about stopping services, see Starting-and-stopping-the-App-Visibility-server-services.

3. Navigate to the following directory, according to your system:

   • (Windows) collector_installationDirectory\collector\bin\db or portal_installationDirectory\portal\bin\db
   • (Linux) collector_installationDirectory/collector/bin/db or portal_installationDirectory/portal/bin/db

   If the portal and collector are installed on the same computer, they share a database, and you only need to perform the procedure in one place.
   If the portal and collector are on separate computers, perform the recovery procedure on both components at the same time so that the content is consistent. Otherwise, the content does not match and the data is incorrect when restored.

4. Run the following script:
   • (Windows) restore-pgsql-dump.bat
   • (Linux) ./restore-pgsql-dump.sh
5. Start the component service.

The database data is recovered.

For more information about how to recover the PostgreSQL database data, see Backup and Restore.