I am following instructions for "Upgrading to Qlik Sense June 2017 from Qlik Sense versions earlier than 3.1 SR2" and am having trouble on step 14.
14.Run the following command to install Qlik Sense and restore your Qlik Sense Repository Database.
The installation starts but I am unclear which options to follow:
- connecting to an existing database fails
- creating a new database does just that
Can anyone assist, should I be seeing some other options referencing the restore?
After tweaking the command prompt to start installation to be:
Qlik_Sense_setup.exe databasedumpfile="C:\Users\xxxx\xxxx\xx xxx\QSR_backup.tar"
A couple of steps after selection of "Install local database" there is a step "Repository Database Superuser Password" acknowledging detection of a Repository database.
However the install ultimately fails.
I note that the size of the backup differs dependent upon method used to generate backup.
pg_dump.exe -h localhost -p 4432 -U postgres -b -F t -f "c:\QSR_backup.tar" QSR
pg_dumpall.exe -p 4432 > [path to dump file]
I have tried restoring both backups without success.
The log file shows:
Action 09:22:24 33 C:/Users/Administrator/xxx/xxxxx/xx xxxx/QSR_backup.tar: No such file or directory
CustomAction CA_RestoreDatabaseFromDumpFile returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Anyone else encountered similar errors/know how to resolve?
without stating the obvious does 'C:/Users/Administrator/xxx/xxxxx/xx xxxx/QSR_backup.tar' exist? can the service account see this or the user doing the install?
Your option one points to 'c:\QSR_backup.tar' and not sure where option two points to...
I have done what you are trying and it worked no problems, but I had uninstalled qlik first (so used the second instructions in step 5)...
The file does exist. I had moved the file hence change of location in reference.
I am continually getting error "The database password entered does not match the database user password specified in the dump file". When creating the backup the superuser password has to be entered so cannot understand why this is being returned. Attached is a file with steps on which I have some questions. If anything clearly awry in here will be grateful if can be advised changes necessary.
Not sure how much more I can help... If i recall I actually logged into the DB and changed the PW interactively (as thinking about it may have also had that error). Then did the dump file.
Sorry not too much help
Thank you Barry - you have helped! I went back and did the password change using PGAdmin tool and the upgrade/restore of database went through OK.
If anyone else has same issue I used these instructions to connect PGAdmin to postgres database.
•Run pgAdmin3.exe from C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin
•Click the power plug button on the top manual bar and enter information
•Name - QSR
•Server - localhost
•Port - 4432 (not the default of 5432)
•User Name - postgres
•Password - the password that you provided on installation.
Then changed the password following second method of changing password under step 3 of upgrade instructions for "Upgrading to Qlik Sense June 2017 from Qlik Sense versions earlier than 3.1 SR2" via