Restore Miria PostgreSQL DB – Windows

Tested with Miria 3.12.0.11 installed in folder c:\Miria on a Windows Server 2019 Standard.
Standard PostgreSQL port 5433 is used.
Test DB to restore is compressed, named TESTDB_5433_DATA_Backup.bz2 and located in Administrator’s download folder.
Note: this article doesn’t handle AMM databse restore.

  1. Prepare new Windows server
  2. Let first Windows updates run and reboot
  3. Install good version of Miria Server + AMM Server if needed
  4. Install Admin UI or use the Web UI
  5. Connect to Miria as Admin (and define first password)
  6. Disconnect Admin
  7. Start a Command Prompt as Administrator
  8. Stop services:
    1. net stop ADA
    2. net stop mm_agent
    3. net stop mm_server
    4. net stop mm_db
    5. net stop ADADB_ADA
  9. Check there is no more process with name starting by “ada” (Task Manager)
  10. Rename actual data folder to data.old
    1. cd c:\Miria\Database\PostgreSQL
    2. move data data.old
  11. Copy an empty data cluster (provided by Miria)
    1. mkdir data
    2. copy c:\Miria\Tools\empty_ADA_cluster.zip c:\Miria\Database\PostgreSQL\data
    3. cd data
    4. PowerShell Expand-Archive -Path empty_ADA_cluster.zip -DestinationPath .
  12. Copy the previous database configuration
    1. copy ..\data.old\postgresql.conf .
  13. Restart the PostgreSQL ADADB_ADA service
    1. net start ADADB_ADA
  14. Unzip the backup file if compressed
    1. c:\Miria\Tools\bzip2 -d C:\Users\Administrator\Downloads\TESTDB_5433_DATA_Backup.bz2
  15. Restore the database
    1. cd c:\Miria\Database\PostgreSQL\bin
    2. psql.exe -p 5433 -q -f ..\TESTDB_5433_DATA_Backup -U postgres
      1. Enter “postgres” without the quote as password
  16. Restart Miria services
    1. net start mm_db
    2. net start mm_server
    3. net start mm_agent
    4. net start ADA
  17. If all OK, don’t forget to set back all services in “automatic”

Contact