topic Re: Upgrading Qlik Sense -- Backup of Repository Database in Management & Governance

Upgrading Qlik Sense -- Backup of Repository Database

Thu, 22 Sep 2016 16:56:48 GMT

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:

Open the Command Prompt in Microsoft Windows.
Produce a dumpfile for the repository database (that is, a single file for the entire database):
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?

Re: Upgrading Qlik Sense -- Backup of Repository Database

lakshmikandh — Thu, 22 Sep 2016 19:59:10 GMT

Hi,

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

Thanks,

Lakshmikandh

Re: Upgrading Qlik Sense -- Backup of Repository Database

Thu, 22 Sep 2016 20:28:04 GMT

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

Re: Upgrading Qlik Sense -- Backup of Repository Database

lakshmikandh — Fri, 23 Sep 2016 09:05:09 GMT

Can you try this Download pg_dump.exe PostgreSQL

Re: Upgrading Qlik Sense -- Backup of Repository Database

Fri, 23 Sep 2016 16:43:14 GMT

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-Backup-Restore-Centr…

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

the <Path> should be explicitly mentioned.

Thanks Lakshmikandh.

Re: Upgrading Qlik Sense -- Backup of Repository Database

rajendra1918 — Wed, 05 Jul 2017 15:07:33 GMT

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

Re: Upgrading Qlik Sense -- Backup of Repository Database

Wed, 05 Jul 2017 16:34:36 GMT

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

Re: Upgrading Qlik Sense -- Backup of Repository Database

rajendra1918 — Wed, 05 Jul 2017 17:07:06 GMT

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

Re: Upgrading Qlik Sense -- Backup of Repository Database

Wed, 05 Jul 2017 17:21:59 GMT

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

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

Re: Upgrading Qlik Sense -- Backup of Repository Database

rajendra1918 — Wed, 05 Jul 2017 18:06:24 GMT

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

Regards,

Rajendra

Re: Upgrading Qlik Sense -- Backup of Repository Database

Wed, 05 Jul 2017 18:23:28 GMT

You should have the repository password, and that is what it asks while taking the back.

In case you did not set the password, follow the link to re-set the password:

Change/add password to repository database

Re: Upgrading Qlik Sense -- Backup of Repository Database

rajendra1918 — Thu, 06 Jul 2017 17:23:18 GMT

Hi Ashutosh- Thanks for your suggestion,

I have followed the steps to take backup.

Getting below error.

C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin>pg_dump.exe -h localhost -p 4432 -U qliksenserepository -b -F t -f "c:\QSR_backup.tar

Password:

pg_dump: [archiver (db)] connection to database "qliksenserepository" failed: FATAL: password authentication failed for user "qliksenserepository"

Can you please suggest any idea to take backup?

Re: Upgrading Qlik Sense -- Backup of Repository Database

Thu, 06 Jul 2017 17:37:53 GMT

I think you still have the problem with repository password, which will be required for taking the back-up.

The below link lets you download a document which gives the exact steps to re-set the password. Try this again, and then take the back-up.

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&cad=rja&uact=8&ved=0ahUKEwiGofrblvXUAhUK3IMKHSGYCCkQFghRMAI&url=http%3A%2F%2Fwww.qlikisrael-support.com%2FKnowledgebase%2FArticle%2FGetAttachment%2F99%2F2092884&usg=AFQjCNHP2qaegq118d6LJadhSuqSXUiVRg

Re: Upgrading Qlik Sense -- Backup of Repository Database

rajendra1918 — Fri, 07 Jul 2017 13:48:34 GMT

Helpful document.

Thank you so much Ashutosh!!

Re: Upgrading Qlik Sense -- Backup of Repository Database

Fri, 07 Jul 2017 13:58:59 GMT

Glad it helped!!!