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.
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 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
there i didnt find any /bin/pg dump.exe
can you please let me know if i missed any step here to take backup?
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:
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
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?
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.