This document covers what to do when there are any changes after installation of PostgreSQL.

What to do after changing PostgreSQL

---

• Update the value of registry : HKEY_LOCAL_MACHINE\SOFTWARE\Samsung\MagicInfo-i\Server\Premium
  • postgrePath : changed path
  • pgport : changed port number
    
• Update Environment Variable
  • the port number of postgreSQL (If there are any changes)
    
• Update config.properties values 
  • If the port number is changed, values of config.properties in runtime folder of MagicInfo have to be changed. Please find the key below and update to new port number. 
  1. 1. wsrm.url=jdbc:postgresql://localhost:5432/magicinfo

     2. org.quartz.dataSource.databaseDS.URL = jdbc:postgresql://localhost:5432/magicinfo

Backup in the environment that uses PostgreSQL

---

1. Backup postgreSQL DB
    
   1. Log in to magicinfo account.
   2. Right click and select "Backup"
   3. Enter the name of backup file and the name of save folder, then click "Backup" button. 
      
      
      
2. Backup runtime folder of MagicINFO 
   
   
   

Restore in the environment that uses PostgreSQL 

---

1. Restore postgreSQL DB
   1. Create new database
      
   2. Set owner to "magicinfo"  
   3. Click "Restore" and restore the previous db
      
      
      
2. Resotre runtime folder 
   1. Restore runtime folder that was backed up