This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to restore the Qlik Sense Repository Database or QRS from a backup.

Here is a link to more information in the Support Knowledge Base:

How to backup or restore the PostgreSQL database in Qlik Sense

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

Video Transcript:

Hi and welcome to Qlik Fix.

This video will demonstrate how to restore the Qlik Sense Repository database or QRS from a backup.

First, verify that only the Qlik Sense Repository database service is running on the machine.

The existing database will need to be removed prior to restoring the QRS backup.

This can be done using PG Admin – a standard database utility.

Open up PG Admin

Create a connection to the server machine hosting the Qlik Sense Repository database.

Port 4432

Postgres user and password.

Here you can see all of the tables where Qlik Sense stores data in the current database that will be dropped.

In PG Admin you could do this with the Delete/Drop option.

I’ll be using these commands copied from the Qlik help site.

Open a command prompt with Administrator privileges from the PostgreSQL 9.6 bin folder.

Copy and paste in the command

Connecting locally,

On port 4432

With the postgres user defined while installing

And dropping the current QSR database.

No other tasks should be running in parallel, so I’ll disconnect PG Admin.

Enter the password

And back to PG Admin to verify that the database has been removed.

You can see that QSR is gone.

Now, copy the Create DataBase command from the Documentation.

The Template0 will create a basic schema, but there will be no tables.

Copy

Paste and run the command

Done.

Back to PG Admin to illustrate.

The QSR has been created with a public schema, but with no tables.

Now we’re finally to the step of restoring from the backup.

This could be done in PG Admin via the Restore command,

Point to the backup tarball, hit restore,

But again, this is a demo of the manual method.

Copy the restore command.

You can see a variable here to the path to the backup file

Copy everything up to that point

Navigate to the QSR backup on an accessible shared drive folder.

Copy the backup locally.

This folder has been created on the local C drive called QSRBackup

An easy way to get the file path is to press Shift and right click,

then select “Copy as path”

Paste it at the end of the command

I recommend adding a “-V” to the command line so that you can actually see some more verbosity to what is happening.

Again, close any tasks or open connections to the database.

Enter the password

And there it goes.

To verify that the data is actually there,

Back to PG Admin one more time.

In the QSR database under tables, now there is all the content.

The QSR has been fully restored.

I hope this helped.

If you'd like more information

Search for answers using the Unified Search

tool on the Support Portal.

it searches across the Support Knowledge Base,

Qlik Community, Qlik Help site and Qlik YouTube channels.

Take advantage of the expertise of peers, product experts and technical support engineers

by asking a question in a Qlik product forum on Qlik Community

And don't forget to subscribe to the Support Updates Blog.

Thanks for watching!

Nailed it!

 This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to configure QlikView and Qlik Sense to publish document links in Qlik Sense Hub. (Unified Hub setup)

Here is a link to more information in the Support Knowledge Base:

How to configure Unified Hub in order to publish QlikView document links in Qlik Sense Hub 

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to activate Qlik Sense Enterprise using Delayed Sync.

Here is a link to more information in the Support Knowledge Base:

https://support.qlik.com/articles/000101148

Retrieve the Signed License Definition using Postman

Retrieve the Signed License Definition using PowerShell

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to fix Qlik bundled extensions not found on server after a recent upgrade.

Here is a link to more information in the Support Knowledge Base:

https://support.qlik.com/articles/000091652

Here are some other helpful articles that are related:
Installing and removing Qlik Sense Extension bundle

Extension Bundle is not showing up in Qliksense HUB but its showing in QMC

Qlik Sense - Can't find the Extension bundle after upgrading to November 2018 version​​​​​​​

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to activate Qlik Insight Bot using the license from your Qlik Sense Enterprise installation.

Here is a link to more information in the Support Knowledge Base:

https://support.qlik.com/articles/000088274

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video will demonstrate how to delete and re-create certificates from Qlik Sense Enterprise.

Here is a link to more information in the Support Knowledge Base:

https://support.qlik.com/articles/000005402

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to apply a Signed License Key to Qlik Sense Enterprise, which is necessary for Cloud deployements and Analyzer Capacity licensing.

Here is a link to more information in the Support Knowledge Base:

https://support.qlik.com/articles/000067750

Here's more information on Help.Qlik.com:
https://help.qlik.com/en-US/sense/April2019/Subsystems/ManagementConsole/Content/Sense_QMC/site-license.htm

Here's more information about Analyzer Capacity licensing:
https://support.qlik.com/articles/000064838

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates the steps needed to reset a forgotten password for the PostgreSQL database in Qlik Sense.
During the installation of Qlik Sense, it’s necessary to provide a password for the PostgreSQL database. Should this password become lost or forgotten, unfortunately there is no way to retrieve it.
It is possible to reset the password by following these steps.

Here is a link to more information in the Support Knowledge Base:

https://support.qlik.com/articles/000005425

Here is where you can find more about downloading and using PGAdmin 4:

https://support.qlik.com/articles/000042413

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport