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 , ensure that you install PostgreSQL 11.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.