Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are looking to back up the PostgreSQL databases for recovery in case of a database crash. I have referred to the following (and a few other) links for backup and restore:
This article mentions backing up QSR and QLogs databases, but there are a few other databases on the Server, namely, Licenses, QSMQ, and SenseServices. So, I have two queries in relation to this:
1. Do we need to backup all of these databases (Licenses, QSMQ, and SenseServices) for a successful restore of the required databases to have Qlik Sense services and Apps up and running as before the database crash?
2. Is it important to backup the logs in QLogs database, considering this database is very large? We are thinking to backup only the schema for this database. If something does go wrong then we are okay to lose the logs (or part of it), unless if losing the logs leads to any type of inconsistency affecting user experience.
The QSR is the minimum viable DB for a restoration procedure. The other ones are generally not needed. To understand when they are needed you need to know where they are used. Whether their uses are important is up to the administrator:
The QSR is the minimum viable DB for a restoration procedure. The other ones are generally not needed. To understand when they are needed you need to know where they are used. Whether their uses are important is up to the administrator: