4.2 On Windows

  1. Stop all services in ZENworks Primary Server.

  2. On the database server, download and extract the migrate_postgres.bat.zip file.

  3. Download and install the PostgreSQL version supported by ZENworks.If you are planning to upgrade to ZENworks , ensure that you install PostgreSQL 11.4.

  4. Open the command prompt as an administrator.The PostgreSQL upgrade log will be generated in the current directory. Hence, it is recommended to change the directory to %USERPROFILE% so that PostgreSQL has permission to write logs.

  5. Copy the batch file in the current directory.

  6. The output will be saved at the%TEMP%\migrate_postgres.log location.

  7. Run the following command to migrate the database. Specify the database superuser password when prompted:

    migrate_postgres.bat -p "<postgresql_install_location"

    Example: migrate_postgres.bat -p C:\Program Files\PostgreSQL\11

NOTE:

  • To see all the available options, run the script without any argument (Example: ./migrate_postgres.bat).

  • After migrating to the external PostgreSQL, ensure that you manually clean the OEM PostgreSQL installation.