Backing up and restoring competition
Agility Manager uses a PostgreSQL database named agilitymanager to run. By backing up and restoring this database, it is possible to backup or restore the entire agility competition. For this purpose, the server provides the application pgAdmin.
pgAdmin is available on port 5050.
Login to pgAdmin
In your internet browser, open the address http://localhost:5050.
Log in with your username and password.
Default login name: admin@agilitymanager.com
Default password: admin
In the left menu, expand AgilityManager and then AgilityManager DB Server. The system will ask for a password.
Default password: admin
Backing up competition
To create a competition backup, it is necessary to back up the agilitymanager database.
In the left menu, open the AgilityManager / AgilityManager DB Server / Databases item, right-click on the agilitymanager database and select Backup... from the menu.
In Filename, write the name of the backup file.
We recommend entering the version of Agility Manager in the file name. Restoration of the database from the backup must be compatible with the version of Agility Manager. This means that restoring a file from a backup needs to be done to the same version of Agility Manager as the backup.
For the file name, do not use diacritics or spaces in the name. A suitable name is, for example, "competition_backup_name_2.0.7", "january-exams-2023_2.0.7" and so on.
Switch from the General tab to the Query Options tab and check the Include DROP DATABASE statement option.
Click on the blue Backup button.
The backup will start and green messages about the status of the backup will be displayed in the lower right corner. The first message warns about the start of the backup Process started and then after the backup is complete, Process completed is displayed. Both reports can then be closed with a cross icon.
The created backup is then available in the Storage Manager tool.
You can open the Storage Manager tool from the Tools / Storage Manager ... main menu.
In Storage Manager you can see a list of all created backups. Individual files with backups can be downloaded and stored in a safe place. The file can be downloaded using the button with the Download icon in the upper right corner of the window.
Always save the backup file in a safe place even off the server. This will protect your data in the event of a server failure.
Competition recovery from backup
To restore a competition from a backup, it is necessary to restore the database agilitymanager.
Restoring the database from a backup will overwrite the current agilitymanager database. Before restoring, make sure that you do not have important data in the current database (for example, previous competition that you have not yet backed up).
In the left menu, open the item AgilityManager / AgilityManager DB Server / Databases, right-click on the agilitymanager database and select Restore... from the menu.
In Filename it is necessary to put the backup file. Click on the folder icon.
You will see a list of backups uploaded to the server.
If you want to restore from a backup that is not stored on the server, but you have a backup file stored on your computer, you need to upload the backup file to the server. To upload a file, click on the ... icon in the upper right corner and upload the file with the backup to the list.
Then select the backup from which you want to restore the database and click on the Select button.
The backup from which you restore the database must have the same version as the Agility Manager version. For example, if you have a backup from Agility Manager version 2.0.6, do not restore it to a version of Agility Manager other than 2.0.6. Incompatibility of data in the database with the correct version of Agility Manager may cause some parts of the system to malfunction.
Switch from the General tab to the Query Options tab and check the Clean before restore option. Click the Restore button.
The restore will start and you will see green status messages in the lower right corner. The first message warns about the start of the recovery Process started and then after the recovery is complete it will show Process completed. Both reports can then be closed with a cross.
