Question:
How do I backup my myQA iON databases?
Answer:
Disclaimer:
Please note that database management, including backups, is the responsibility of the customer. For further assistance, consult your database administrator to ensure proper setup.
Stop the following services:
- Orthanc
- IBA Dosimetry myQA iON
- IBA Dosimetry Reverse Proxy
Backup
Step 1
Backup the Orthanc folder. For default installations, it is located here: C:\Orthanc
Backup the folder C:\ProgramData\IBA\myQA iON\
Step 2
Navigate to C:\Program Files\PostgreSQL\9.6\pgAdmin 4\bin and run pgAdmin4.exe. This will open a browser which will connect to http://127.0.0.1:53225/browser/.
At first access you need to set a password for future access of pgAdmin 4. Then you can access the database server by clicking on "PostgreSQL 9.6". You need to enter the database password which was set during installation:
Step 3
Right click on the "myqaion" database -> backup and define the file name. The format should be chosen as "Custom". Continue with the backup.
Repeat the backup for the "orthanc" database.
Step 4
Restart the services:
- Orthanc
- IBA Dosimetry myQA iON
- IBA Dosimetry Reverse Proxy
Restore
Step 1
Navigate to C:\Program Files\PostgreSQL\9.6\pgAdmin 4\bin and run pgAdmin4.exe. This will open a browser which will connect to http://127.0.0.1:53225/browser/.
At first access you need to set a password for future access of pgAdmin 4. Then you can access the database server by clicking on "PostgreSQL 9.6". You need to enter the database password which was set during installation.
Step 2
Right click on the database called "myqaion" and click "Delete/Drop".
Step 3
Right click on "Datesbases -> Create -> Database". Define the name as "myqaion" and save it.
Step 4
Right click on the "myqaion" database and select "Restore". Select the database that should be restored and confirm with "restore".
Step 5
Repeat the steps 2-5 for the "orthanc" database.
Step 6
Replace the Orthanc folder here: C:\Orthanc. If the path of that Orthanc folder is different from the path mentioned here, please replace it at the according path.
Step 7
Restart the services:
- Orthanc
- IBA Dosimetry myQA iON
- IBA Dosimetry Reverse Proxy