Backup and restore

Network Olympus provides the ability to create backups of the database used by the application.
A backup can be used to restore the previous version of the database, for example due to loss of information in the live version.

In the current version of Network Olympus, database backups can only be done manually.

Working with PostgreSQL

A backup must be performed on the computer where Network Olympus is installed.

Before creating a backup, it's important to stop the Network Olympus Core Service (OlympusCore).

Tools used for creating backup and restoring are located in the application folder: C:\Program Files (x86)\Network Olympus\Database\bin by default.

Successful restoration from backup can only be guaranteed on the same application version as was used to make the backup.

To create a backup, use the following command:

pg_dump.exe -h localhost -p 5432 -d olympus -U root -w -c -f backup.sql

To restore from a backup:
psql.exe -h localhost -p 5432 -d olympus -U root -w -f backup.sql

where 5432 is the default port used by the database;
root is the database owner's default username;
backup.sql is a user-defined name of the file containing the backup.

The port can be set during the installation of the program.
If these values have been changed, you can look them up in the registry at HKEY_LOCAL_MACHINE\SOFTWARE\SoftinventiveLab\Olympus\Database

Modification of this registry string may cause program malfunction.