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

Viewing 0 reply threads
  • Author
    Posts
    • #10480
      Eric CollartEric Collart
      Keymaster

        Note: Restoration method changed for Miria 2021 R2 (3.14) and later, the below procedure cannot be used for those newer versions.

        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 0 reply threads
    • You must be logged in to reply to this topic.