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 값 업데이트만약 포트값이 수정되었다면 매직인포 runtime 폴더 안의 config.properties의 값도 수정되어야 합니다. 아래의 key 값을 찾아 바뀐 포트값으로 업데이트 하세요 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

PostgreSQL를 사용하는 환경에서의 백업

1. 매직인포 postgreSQL DB 백업 Image Removed 
   1. magicinfo 계정으로 로그인
   2. 우클릭 후 backup 선택
   3. 백업 파일 이름과 저장 폴더 이름 입력 후 백업 클릭 Image Removed
2. 매직인포 Runtime 폴더 백업  Image Removed

PostgreSQL를 사용하는 환경에서의 복원 

Image Removed

Backup in the environment that uses PostgreSQL

1. Backup postgreSQL DB
   Image Added 
   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. 
      Image Added
      
      
2. Backup runtime folder of MagicINFO 
   Image Added
   
   

Restore in the environment that uses PostgreSQL 

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