Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Not applicable

Upgrading Qlik Sense -- Backup of Repository Database

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

Questions:

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?

14 Replies
lakshmikandh
Valued Contributor II

Re: Upgrading Qlik Sense -- Backup of Repository Database

Hi,

Not sure what could be the reason, did you search for "pg_dump.exe" file in your system under Qlik folder?

Thanks,

Lakshmikandh

Not applicable

Re: Upgrading Qlik Sense -- Backup of Repository Database

Yes I did search for "pg_dump.exe" and there is none.

lakshmikandh
Valued Contributor II

Re: Upgrading Qlik Sense -- Backup of Repository Database

Not applicable

Re: Upgrading Qlik Sense -- Backup of Repository Database

Problem Solved: I was looking for the pg_dump file in C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.3

but actually I should have been looking at: C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin

This should be mentioned in the Qlik Help page:https://help.qlik.com/en-US/sense/2.2/Subsystems/PlanningQlikSenseDeployments/Content/Server/Server-...

where they mention:cd "<Path>\Qlik\Sense\Repository\PostgreSQL\<database version>\bin"

the <Path> should be explicitly mentioned.

Thanks Lakshmikandh.

rajendra1918
New Contributor II

Re: Upgrading Qlik Sense -- Backup of Repository Database

Hi Ashutosh- i am trying to take back of 3.1 and need to upgrade QS to QS june 2017.

Is there any step by procedure to do it?

If yes can you share any document on it. That should be much helpful .

Regards,

Rajendra

Not applicable

Re: Upgrading Qlik Sense -- Backup of Repository Database

Hi Rajendra,

                    Assuming that you want to move to Shared Persistence, you will probably want to do the following steps:

1. Upgrade 3.1.0 synchronized persistence to 3.1.2 synchronized persistence.

2. Upgrade 3.1.2 synchronized persistence to 3.2.4 shared persistence.

3. Upgrade 3.2.4 shared persistence to June 2017.


In my case we had 3.1.0 and we moved to 3.2.4 (so we followed steps 1 & 2) and will be doing the upgrade to June 2017 in the coming week.

Hope this helps.

Thanks,

Ashutosh

rajendra1918
New Contributor II

Re: Upgrading Qlik Sense -- Backup of Repository Database

Thanks Ashutosh for prompt response.

we are also using 3.1 now. first i want to take backup andt i have followed the steps in below link

Backing up a site manually ‒ Qlik Sense

there i didnt find any /bin/pg dump.exe

C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.3>

+---base

    ¦   +---1

    ¦   +---12024

    ¦   +---12029

    ¦   +---16384

    +---global

    +---pg_clog

    +---pg_multixact

    ¦   +---members

    ¦   +---offsets

    +---pg_notify

    +---pg_serial

    +---pg_snapshots

    +---pg_stat

    +---pg_stat_tmp

    +---pg_subtrans

    +---pg_tblspc

    +---pg_twophase

    +---pg_xlog

        +---archive_status

can you please let me know if i missed any step here to take backup?

Regards,

Rajendra

Not applicable

Re: Upgrading Qlik Sense -- Backup of Repository Database

You should look into Program Files and NOT into Program Data, as below:


cd "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\<database version>\bin"

rajendra1918
New Contributor II

Re: Upgrading Qlik Sense -- Backup of Repository Database

Thank you Ashutosh, It is prompting for the password.But is there any way to skip this step?

Regards,

Rajendra

Community Browser