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

Viewing 0 reply threads
  • Author
    Posts
    • #10488
      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 /Miria on a CentOS 8.4 server.
        Standard PostgreSQL port 5433  is used.
        Test DB to restore is compressed, named miria-centos8_5433_DATA_Backup.bz2 and located in /root.
        Note: this article doesn’t cover the eventual AMM database restore.

        1. Prepare new Linux server
        2. Run first Linux updates
          1. yum update
        3. Reboot for safety
          1. reboot
        4. Install good version of Miria Server + AMM server if needed
        5. Optional: Install Admin UI on a Windows workstation if needed
        6. Optional: Connect to Miria Linux server as root (and define first password) with Admin UI or Web UI
        7. Only if step 6 done: disconnect from DB
        8. Stop services
          1. systemctl stop ADA_ADA
          2. systemctl stop amm_agent
          3. systemctl stop amm_server
          4. systemctl stop amm_db
          5. systemctl stop ADADB_ADA
        9. Check there is no more process with name starting by “ada”
          1. ps -ef | grep -i ada
        10. Rename actual data folder to data.old
          1. cd /Miria/Database/PostgreSQL
          2. mv data data.old
        11. Copy an empty data cluster (provided by Miria)
          1. mkdir data
          2. cp /Miria/Tools/empty_ADA_cluster.tgz /Miria/Database/PostgreSQL/data/
          3. gunzip data/empty_ADA_cluster.tgz
          4. cd data
          5. tar -xvf empty_ADA_cluster.tar
          6. cd ..
          7. mkdir data/log
          8. sudo chown -R postgres:postgres data
          9. sudo chmod -R 700 data
        12. Copy the previous database configuration
          1. cp data.old/postgresql.conf data/
            1. Answer “y” to replace the existing file
        13. Restart the PostgreSQL ADADB_ADA service
          1. systemctl start ADADB_ADA
        14. Unzip the backup file
          1. bunzip2 /root/miria-centos8_5433_DATA_Backup.bz2
        15. Restore the database
          1. su postgres
          2. cd /Miria/Database/PostgreSQL/bin
          3. ./psql -p 5433 -q -f ../miria-centos8_5433_DATA_Backup
            1. Enter “postgres” without the quote as password
          4. exit (when finished)
        16. Restart Miria services
          1. systemctl start amm_db
          2. systemctl start amm_server
          3. systemctl start amm_agent
          4. systemctl start ADA_ADA
        Spread the love
    Viewing 0 reply threads
    • You must be logged in to reply to this topic.