Skip to main content

Upgrading to Qlik Sense June 2017 or later after uninstalling Qlik Sense 3.1 SR2 or later

If you have uninstalled Qlik Sense but maintained your PostgreSQL database, and you want to upgrade to Qlik Sense June 2017 or later, you must create a database dump file and restore the PostgreSQL database manually. You will also need to manually reconfigure any custom parameters.

Do the following:

  1. Copy the PostgreSQL folder from %ProgramData%\Qlik\Sense\Repository\PostgreSQL to a temporary location outside of the %ProgramData% folder.
  2. Download and install PostgreSQL version 9.6 from the PostgreSQL website. For more information, see Installing and configuring PostgreSQL.
  3. Open a Command Prompt in Microsoft Windows.
    Warning: The pg_ctl.exe command should not be run as an administrator.
  4. Navigate to the location where the PostgreSQL repository database is installed, %ProgramFiles%\PostgreSQL\<database version>\bin, and run the following commands:
    1. pg_ctl.exe start -w -D "C:\SenseDB\9.6"
    2. set PGUSER=postgres
    3. set PGPASSWORD=password
    4. pg_dumpall.exe > [<path to dump file>]
    5. pg_ctl.exe stop -w -D "C:\SenseDB\9.6"
  5. In the Command Prompt window, navigate to the folder containing the Qlik_Sense_setup.exe file.

  6. Run the following command to install Qlik Sense and restore your Qlik Sense Repository Database.

    Qlik_Sense_setup.exe databasedumpfile=<path_to_dump_file>

    Warning: The path to the dump file must be entered as an absolute path. Using a relative path will result in an installation failure.
  7. Follow the setup to complete the installation. For more information, see Deploying Qlik Sense Enterprise on Windows.