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

[Gerald_U]

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):

1. 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
      
      
      
      
      
2. Download the new major version of PostgreSQL you want to upgrade to. For example, you may be moving from 12.x to 14.x.
3. Install the new PostgreSQL instance on the Qlik Enterprise Manager host
   
   for PostgreSQL-specific installation instructions, see PostgreSQL's manuals. 
   
   
4. In the new PostgreSQL instance, create a New User identical to the one used in the previously backed-up database 
   
   
5. In the new PostgreSQL instance, create a New Database with an identical name to the previously backed-up database
   
   
6. 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
      
      
      
      
7. 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
   
   
8. Verify you can see the old analytics information

Environment

• Qlik Enterprise Manager