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

  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.