14 Replies Latest reply: Jul 7, 2017 9:58 AM by Ashutosh Mishra RSS

    Upgrading Qlik Sense -- Backup of Repository Database

    Ashutosh Mishra

      I am trying to upgrade Qlik Sense 2.2.4 to Qlik Sense 3.1.


      1. Do we need to take a backup of the Repository Database?

      2. I did go through help and for backing up the repository database, it suggests the following steps:

      Make a backup of the repository database:

      1. Open the Command Prompt in Microsoft Windows.
      2. Produce a dumpfile for the repository database (that is, a single file for the entire database):
          1. cd "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\<database version>\bin"
          2. pg_dump.exe -h localhost -p 4432 -U postgres -b -F t -f "c:\QSR_backup.tar" QSR
          3. If you are prompted for the
        PostgreSQL super user password, enter the password that was given during the installation of Qlik Sense.
        1. Make a backup of the dumpfile for the repository database.


      But in my case I dont find the "bin" folder in my "PostgreSQL\9.3" folder?

      3. Further, I dont see the Repository Snapshot Manager, to have the backup of the Repository Database?

         The help says : The RSM is available in %ProgramFiles%\Qlik\Sense\Repository\Util\RepositorySnapshotManager after installation of the Qlik Sense software.


      How can I take the backup of the repository database with above circumstances?