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
    Image Modified
• 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
   Image Modified 
   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 
   Image Modified
   
   

Restore in the environment that uses PostgreSQL 

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