This document covers what to do when there are any changes after installation of PostgreSQL.
What to do after changing PostgreSQL
Describes the considerations when changing the installation folder or port by changing the PostgreSQL version.
- 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)
- 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.
- wsrm.url=jdbc:postgresql://localhost:5432/magicinfo
org.quartz.dataSource.databaseDS.URL = jdbc:postgresql://localhost:5432/magicinfo
Backup in the environment that uses PostgreSQL
To backup MagicINFO Server, you need to backup DB and runtime folder.
- Backup postgreSQL DB
- Log in to magicinfo account.
- Right click and select "Backup"
- Enter the name of backup file and the name of save folder, then click "Backup" button.
- Backup runtime folder of MagicINFO
Restore in the environment that uses PostgreSQL
- Restore postgreSQL DB
- Create new database
- Set owner to "magicinfo"
- Click "Restore" and restore the previous db
- Create new database
- Resotre runtime folder
- Restore runtime folder that was backed up
- Restore runtime folder that was backed up