Well, I think I figured out the answer to my own question. When we went from 3.2 to September Release, the upgrade mandated that we go from synchronized to shared persistence. Previously we were using the QLIK util, RepositoryManager.exe, to conduct the back ups. This util is not supported with shared persistence, which means that it is no longer supported in the new versions of QLIK. Apparently QLIK will be providing a new util, but that is still forthcoming. I am now trying to figure out how to automate the back up of QLIK using Powershell and the postgres util pg_Dump...but admittedly that is not looking good.
I made a powershell script to execute my nightly backup.
Here's what you have to do :
As we goint to use pgpass function of postgres sql, you have to add a system variable named PGPASSFILE and value D:\PGPASSFILE\pgpass.conf in my example
Make a text file named pgpass.conf and write the line below : Replace the xxx by your superuser password
then create a new ps1 file and write this :
$Today = Get-Date -UFormat "%Y%m%d_%H%M"
$StartTime = Get-Date -UFormat "%Y%m%d_%H%M"
$PostGreSQLLocation = "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin"
$PostGresBackupTarget = "D:\Backup"
#$PGPASSFILE = "D:\PGPASSFILE\pgpass.conf"
write-host "Backing up PostgreSQL Repository Database ...."
.\pg_dump.exe -h localhost -p 4432 -U postgres -b -F t -f "$PostGresBackupTarget\QSR_backup_$Today.tar" QSR
write-host "PostgreSQL backup Completed"
$EndTime = Get-Date -UFormat "%Y%m%d_%H%M%S"
write-host "This backup process started at " $StartTime " and ended at " $EndTime
Then, test your script and it should works.
You just have to plan it in task scheduler in windows server.
hope it helps !