topic Re: Sense June 2017 - Backups w/ RSM? in Management & Governance

Sense June 2017 - Backups w/ RSM?

lucienorrin — Mon, 10 Jul 2017 13:54:46 GMT

Does the repository snapshot manager work in the June 2017 update?

I was told it only works with synchronized persistence, which is not supported in the June 2017 release.

Thanks!

Re: Sense June 2017 - Backups w/ RSM?

Arkadiusz-Misiewicz — Mon, 28 Aug 2017 07:39:21 GMT

Hi Lucien,

RSM is no longer supported in June 2017 release. From 'Qlik Sense June 2017 release notes':

Repository Snapshot Manager tool removed

The automatic backup and restore tool Repository Snapshot Manager has been removed, as it was

intended for deployments using synchronized persistence. Please refer to the online help for manual

backup and restore procedures.

Please refer to 'Backing up and restoring' sections of our help site. We are currently working on a new tool for these processes - supporting shared persistence, and hoping to have it available within the next release. Stay tuned.

Best Regards,

Arkadiusz Misiewicz

Re: Sense June 2017 - Backups w/ RSM?

Tue, 19 Sep 2017 14:33:00 GMT

Thanksfully RSM was removed.

PG_Dump is much better:

Stop all Sense services except QRD (Qlik Sense Repository Database)

Using CMD (like Administrator) enter to C:\ProgramFiles\Qlik\Sense\Repository\PostgreSQL\<database version>\bin

and enter this command to backup: pg_dump.exe -h localhost -p 4432 -U postgres -b -F t -f "c:\backup_name.tar" QSR

and this one when you want to restore: pg_restore.exe -h localhost -p 4432 -U postgres -d QSR "c:\backup_name.tar"

if you have any problem restoring try this:

dropdb -h localhost -p 4432 -U postgres QSR

createdb -h localhost -p 4432 -U postgres -T template0 QSR

pg_restore.exe -h localhost -p 4432 -U postgres -d QSR "c:\QSR_backup.tar"

Cheers

Re: Sense June 2017 - Backups w/ RSM?

Arkadiusz-Misiewicz — Tue, 19 Sep 2017 15:01:39 GMT

Hi Crisian San,

both RSM and the upcoming tool I mentioned in my initial response are build around the pg_dump and you are most welcome to use it when backing up and restoring your database. Our intention is to provide users with a tool that (liked RSM used to) with a single command line would allow to back up and restore entire Qlik Sense site, meaning installation of Qlik Sense and the database, handling certificates, shared and supporting content, etc.

Thank you for your post!

Best Regards,

Arkadiusz Misiewicz

Re: Sense June 2017 - Backups w/ RSM?

tobiasstrobel — Thu, 11 Jan 2018 10:34:58 GMT

Hi Arkadiusz,

can you tell me if there is already a tool for this case?

Alternatively: Do you have ideas, how to realise the backup of the database automatically?

Best Regards,

Tobias

Re: Sense June 2017 - Backups w/ RSM?

Arkadiusz-Misiewicz — Tue, 16 Jan 2018 09:50:54 GMT

Hi Tobias,

from and including September 2017 release of Qlik Sense, all releases come with QlikSenseUtil tool located in %ProgramFiles%\Qlik\Sense\Repository\Util\QlikSenseUtil. There is also Readme.txt file included in the same location that described the usage of the tool for backing-up and restoring Qlik Sense.

Best Regards,

Arkadiusz