If you are using the OEM PostgreSQL database in ZENworks 2017 Update x, then ensure that you migrate to an external PostgreSQL database before upgrading your zone to ZENworks 2020.
Using the database migration script, you can migrate the database. The script file can be downloaded from the following locations:
Download the OEM PostgreSQL to External PostgreSQL Migration script
You can download the script file, and then perform the following steps to migrate to an external PostgreSQL database:
Take a backup of the database.
Stop all services in ZENworks Primary Server.
On the database server, download and extract the migrate_postgres.sh.zip file.
Download and install the PostgreSQL version supported by ZENworks.
If you are planning to upgrade to ZENworks 24.2, ensure that you install PostgreSQL 12.14.
Change the permission for the script by running the chmod 755 migrate_script.sh command.
The script log will be saved in the /tmp/migrate_postgres.log location.
Run the following script:
./migrate_postgres.sh -p <PostgreSQL_Installed_Directory> --database <zenworks_db_name> --password <superuser password>
Example: ./migrate_postgres.sh -p /usr/pgsql-11/ --database zenworks_database --password novell
NOTE:
To see all the available options, run the script without any argument. (Example: ./migrate_postgres.sh)
After migrating to the external PostgreSQL, ensure that you manually clean the OEM PostgreSQL installation.