https://www.novell.com/documentation/zenworks-24.4/zen_sys_db_mgmt/data/t4q4fsvaxqx8.html
It seems the documentation is a bit lacking so I thought I would post a few quick tips...
- Check Available Diskspace: df -h /var/opt/microfocus/pgsql/data
- Check Current Space used by DB: du -sh /var/opt/microfocus/pgsql/data
- Make sure Free Space is at least 2x of Used Space. (If even close....I would look at freeing space....)
Make sure to Stop the following services on all ZCM Services except the DB Server. (The script will handle it for the DB Server itself...)
- systemctl stop microfocus-zenadmin-mgmt.service
- systemctl stop microfocus-zenclient-mgmt.service
- systemctl stop microfocus-zenloader.service
Applying the Update....
- Extract zenworks-postgres-migration-tool-1.zip on your PC and use WinSCP to copy the "postgresql-migration-tool" directory structure to the /tmp folder on your appliance
- (Edit: Actually I would not use any other subfolder structure than under /tmp. Only certain folders are exposed to Docker Instances so other locations may be fail. So be safe and use /tmp. That is just my personal thought..)
- By Default, the folder should inherit 0755 permissions to allow the needed script to run...if not update it using WinSCP. (Copying to folders other than /tmp may not give correct default permissions...)
- Use Putty to connect to the Appliance Serve Bash prompt and change to the "/tmp/postgresql-migration-tool" directory (Or wherever you copied it....)
- Run sh postgresql-migration-tool.sh
- When prompted for an administrative account, the value will be "Case-Senstive" so the built-in account will be "Administrator" and not "administrator", even though most other places "administrator" will work.
- This will require a Non-LDAP Based ZCC Admin, since services will not be in a state to verify LDAP based credentials.
- Don't forget to restart services on other servers after you are done: microfocus-zenworks-configure -c Start
- It may take longer than normal for the ZCM Services to fully restart the first time after the migration. If you get a 503 for a while .... just be patient.
- A few days after all appears well....Cleanup -> /var/opt/microfocus/pgsql/data_old folder
Comment Away and let me know if I missed anything important.....
--
If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button
Be sure to "Like" My (and a few others) Cool Solutions below!
https://community.microfocus.com/members/craigdwilson/bookmarks