Backing up the Qlik Enterprise Manager PostgreSQL database and restoring it to a new major PostgreSQL version using pgAdmin

Gerald_U — Thu, 19 Dec 2024 15:05:03 GMT

This article provides the necessary steps to back up an existing Qlik Enterprise Manager PostgreSQL database before restoring it to a new major version of PostgreSQL. We will use pgAdmin for the process.

For Qlik Enterprise Mangaer's System Requirements, including PostgreSQL compatibility, see Additional software requirements.

If you are upgrading within a major PostgreSQL release (example: 14.5 to 14.8), no manual backup and restore is necessary. Simply download the PostgreSQL installer and upgrade your current instance.

If you are upgrading to a new major PostgreSQL release (example: 12.x to 14.x):

Backup the existing PostgreSQL database of your Qlk Enterprise Manager instance using pgAdmin:
1. Right-click on the existing PostgreSQL database (in our example: postgres)
2. Select Backup
3. Fill in the required information:
  
  File Name: Your backup file name
  Format: TAR
  Role: Current role name
4. Click Backup
Download the new major version of PostgreSQL you want to upgrade to. For example, you may be moving from 12.x to 14.x.
Install the new PostgreSQL instance on the Qlik Enterprise Manager host

for PostgreSQL-specific installation instructions, see PostgreSQL's manuals.
In the new PostgreSQL instance, create a New User identical to the one used in the previously backed-up database
In the new PostgreSQL instance, create a New Database with an identical name to the previously backed-up database
Restore your backup to the new database using pgAdmin:
1. Right-click on the newly created database (in our example: postgres)
2. Select Restore
3. Fill in the required information:
  
  Format: Custom or Tar
  File Name: Your backup file name
  Role: Previous role name
4. Click Restore
Point Qlik Enterprise Manager to the new PostgreSQL database by following the steps in Unable to start collector in analytics module of Qlik Enterprise Manager when changing the database
Verify you can see the old analytics information

article Backing up the Qlik Enterprise Manager PostgreSQL database and restoring it to a new major PostgreSQL version using pgAdmin in Official Support Articles

Backing up the Qlik Enterprise Manager PostgreSQL database and restoring it to a new major PostgreSQL version using pgAdmin

Environment