Home Forums Miria forums – EN Miria : How To ? Restore Miria PostgreSQL DB – Windows

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #10480
    Eric CollartEric Collart
    Keymaster

    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”
Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.