Before you run the PostgreSQL Migration tool, you should accomplish the set of prerequisites mentioned below. Also, you need to perform a few steps while preparing for the upgrade process. Once you complete these steps, then you can run the PostgreSQL Migration tool.
NOTE:Embedded PostgresSQL 16.x is not supported on ZENworks 24.2 or prior versions, and is meant for transition period only. You must upgrade to ZENworks 24.4 or later versions immediately after upgrading to PostgreSQL 16.x.
Before you run the PostgreSQL Migration tool, ensure you meet the following prerequisites:
Since the tool is case-sensitive, make sure to enter the exact user name, including the proper capitalization.
Run this tool only on the ZENworks server with Embedded PostgreSQL having Database Role
Run this tool on ZENworks 23.4 server or later version on the Linux platform
If the zone has multiple Primary Servers, then stop the following ZENworks services running on all the other Primary Servers in the zone:
Micro Focus ZENworks Administration Management
Micro Focus ZENworks Client Management
Micro Focus ZENworks Loader
Stop the ZENworks Services on all Primary servers by running the microfocus-zenworks-configure -c Startcommand.
After running the command, under Action, select Stop.
Ensure the server machine has sufficient disk space (more than twice the size of the existing PostgreSQL data folder (/var/opt/microfocus/pgsql/data/) size
Ensure the required Docker version is 24.x and the Docker Compose version: 2.10.2 before running the PostgreSQL Migration tool.
If you have Windows Primary Server with embedded PostgreSQL on ZENworks 23.4, then first you need to migrate either to Linux primary server or ZENworks appliances. For more information, see ZENworks Server.
After you migrate from Windows Primary Server, then run the PostgreSQL Migration tool. To do so, perform the following steps:
Extract the PostgreSQL Migration tool (zenworks-postgres-migration-tool.zip) to any directory path <EXTRACT_LOCATION>:
unzip zenworks-postgres-migration-tool.zip
To start the PostgreSQL Migration tool, run the following command and follow the prompts:
sh postgresql-migration-tool.sh
You can view the PostgreSQL migration logs at:
<EXTRACT_LOCATION>/logs/postgresql-migration-tool.log
NOTE:The PostgreSQL Migration tool will stop the services itself on the server where the upgrade is getting performed and will restart the stopped services once the execution completes.
Once the PostgreSQL upgrade is complete, start the ZENworks services on all the other Primary Servers in the zone using the following command:
microfocus-zenworks-configure -c Start
NOTE:
In case if the upgrade fails, the PostgreSQL Migration tool will automatically rollback the changes.
It is recommended to clean-up the /var/opt/microfocus/pgsql/data_old folder post successful upgrade of embedded PostgreSQL.