This procedure helps ensure a smooth transition with minimal downtime and data integrity preserved. Always test in a non-production environment first when possible.
Backup, Uninstall, Reinstall, and Restore Procedures
Important Notes Before Starting:
- The database backup and restoration step is the most critical. Ensure it completes successfully before proceeding.
- Run all Command Prompts as Administrator.
- These instructions are based on standard JMP Live on-premises deployment practices (involving JMP Pro, PostgreSQL database via JMP Live Database installer, Keycloak, and JMP Live services).
- Schedule this during a maintenance window, as services will be offline.
Step 1: Preparation and Backup
1. Backup configuration files to new folder (i.e. C:\Backup)
- Locate and copy the .env files located in the JMP Pool and JMP Live installation directories. These 2 will be reused.
- Backup the Keycloak .conf file (for reference only; it cannot be directly reused).
- Important: Ensure any certificates (certs) are not stored in the default Program Files folder, as it will be removed during uninstallation. Move them to a safe location if needed.
2. Stop all JMP Live services
- Open Services (services.msc) and stop:
- jmppoolsvc
- webjmpsvc
- JMP Live Keycloak
Step 2: Database Backup
1. Open an elevated Command Prompt (Run as Administrator).
2. Navigate to (cd) the Backups folder
3. Execute the following database backup command:
"C:\Program Files\PostgreSQL\13\bin\pg_dump" -Fc -b -h olddbhost -U dba_webjmp -f webjmp.dump webjmp
- Update the file path in the command to match your installation.
4. Monitor progress as this may take significant time depending on database size.
5. Verify the backup file exists and is not empty/corrupt before continuing.
- This step is critical as a failed backup can result in data loss.
- The entire JMP Live database must be backed up and restored otherwise it is not guaranteed that the new deployment will work properly.
Step 3: Uninstall Existing Components
Uninstall the following in any order (via Control Panel > Programs and Features or Add/Remove Programs):
- JMP Live
- JMP Pro
- JMP Live Database (PostgreSQL instance)
- Keycloak
Step 4: Installation and Restoration of Database
1. Install the JMP Live Database component found in the JMP Live self-extracting executable
2. Using the same elevated Command Prompt and Backups folder, run the following restore command.
"C:\Program Files\PostgreSQL\13\bin\pg_restore" -Fc -h newdbhost -U dba_webjmp -d webjmp webjmp.dump
- Update the file path in the command to match your installation.
3. Confirm the restore completes successfully (check logs or query the database).
Step 5: Install other JMP Live Components
Install in this exact sequence:
1. JMP Pro
2. Keycloak
- During installation, enter the required administrator and database settings.
- Open the backed-up Keycloak .conf file in Notepad to use as a reference for configuration values (e.g., ports, admin credentials, database connection).
3. JMP Live
- During installation, the prompts do not need to be fully accurate if you plan to overwrite .env files post-installation.
- Ensure the JMP Pro installation path is correctly specified when prompted (or update it later in the JMP Pool .env file; i.e. change any 18 → 19 references).
Step 6: Post-Installation Configuration
1. Stop services again (if started automatically):
- Open Services (services.msc) and stop:
- jmppoolsvc
- webjmpsvc
- JMP Live Keycloak
2. Overwrite configuration files
- Replace the new .env files in the JMP Pool and JMP Live directories with your backed-up copies.
- Review and update any version-specific paths (i.e. JMP Pro path 18 → 19). These can be edited in Notepad.
- Save changes.
3. Launch JMP Live
- Navigate to: `C:\Program Files\JMP\JMP Live\` (or your install path).
- Run `launch.cmd` as Administrator.
- Allow both command prompt windows to complete initialization, then close them.
4. Start services
- Open Services (services.msc) and start:
- jmppoolsvc
- webjmpsvc
- JMP Live Keycloak
Step 7: Final Verification and Reauthorization
1. Access the JMP Live Administrator web interface.
- https://URL/admin/login
2. Log in as an Administrator.
3. Go to the Admin tab.
4. Reauthorize JMP Live (follow on-screen prompts to complete licensing / connection validation).
5. Test key functionality: publish a sample report from desktop JMP Pro, verify user access, check data refresh, etc.
If issues occur:
- Check service status and logs.
- Verify database connectivity and Keycloak realm settings.
- Consult official JMP Live Installation Instructions or contact JMP Technical Support.