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.3 from the PostgreSQL website. For more information, see Installing and configuring PostgreSQL.
  3. Open a Command Prompt in Microsoft Windows.
    Warning noteThe 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.3"
    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.3"
  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 noteThe 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 Qlik Sense installation.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!