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 2020 Update 2, ensure that you install PostgreSQL 12.4.
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.