Error In Backing up a Qlik Sense site

[akbarhussein]

I am trying to do the Backing up a Qlik Sense site, Below is the  command which I run in command Prompt :

Command Start:

C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil\QlikSenseUtil.exe -backup -databaseHostname="localhost" -databasePassword="XYZXYZ" -path="C:\QlikSense backup" -certificatePassword="cert@123".

Command End:

Its Showing me the Below Issue.

Issue message start:

QlikSenseUtil, mode-backup Exception in thread main, msg-28P01: "postgres", code=-2147467259 password

Issue message End:

[rubenmarin]

Hi, that error means that the passowrd you are using in the command is not the super user password, you need to pass the current superuser password.

If you have lost the password you can try this: https://help.qlik.com/en-US/sense-admin/February2022/Subsystems/DeployAdministerQSE/Content/Sense_De...

Or this (a backup or snapshot will be nice before starting this procedure): https://community.qlik.com/t5/New-to-Qlik-Sense/Change-add-password-to-repository-database/td-p/8127... 

[Boris_I]

Hi @akbarhussein ,

You can also do the backup without using that tool, just follow the steps from that article.

https://community.qlik.com/t5/Knowledge/How-to-backup-or-restore-the-PostgreSQL-database-in-Qlik-Sen...

Regards

Boris

[akbarhussein]

hi rubenmarin,
Thanks for previous help, now I took super user password but now its giving me new error message, Below is a error message.

Error message Start:

This app can't run on your pc to find a version for your pc, check with the software publisher.

Error message End:

Below are details of My windows and qlik sense Versions.

Windows Version: Windows Server 2012 R2 Standard
Qlik sense Version: Qlik Sense June 2020

The pg_dump.exe is not showing the Version details.

Kindly check the attached screen shots if needed.

Thanks.

[akbarhussein]

hi @Boris_I  thanks for advice,

I was followed same link which you give me above,

now previous issue is solved but I am facing new error, Below is a error message.

Error message Start:

This app can't run on your pc to find a version for your pc, check with the software publisher.

Error message End:

Below are details of My windows and qlik sense Versions.

Windows Version: Windows Server 2012 R2 Standard
Qlik sense Version: Qlik Sense June 2020

The pg_dump.exe is not showing  its Version details.

Kindly check the attached screen shots if needed.

thanks

[Boris_I]

Hi @akbarhussein 

What version of PowerShell are you using?

please run this command in PowerShell 

$psversiontable

[akbarhussein]

hi @Boris_I ,

My powerShell version is 4.

I was try in command prompt as well as in Microsoft powerShell.

But getting same error in both.

[Boris_I · Accepted solution]

Hi @akbarhussein,

Looking at the screenshot i have the feeling that you are not following the instruction.

You run this command to be in the right directory

cd "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin"​

then you only need to copy and paste this one

\pg_dump.exe -h localhost -p 4432 -U postgres -v -b -F t -f "c:\backup\QSR_backup.tar" QSR​

And that it