Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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?
Hi,
Not sure what could be the reason, did you search for "pg_dump.exe" file in your system under Qlik folder?
Thanks,
Lakshmikandh
Yes I did search for "pg_dump.exe" and there is none.
Can you try this Download pg_dump.exe PostgreSQL
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.
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
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
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
You should look into Program Files and NOT into Program Data, as below:
cd "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\<database version>\bin"
Thank you Ashutosh, It is prompting for the password.But is there any way to skip this step?
Regards,
Rajendra