topic Re: How to restore centralized logging database in Management & Governance

How to restore centralized logging database

rohitk1609 — Tue, 04 Sep 2018 05:11:46 GMT

Hi Techies,

I was trying to backup and restore shared persistence site with the help of following document:

https://help.qlik.com/en-US/sense/September2017/Subsystems/PlanningQlikSenseDeployments/Content/Deployment/Backing-up-a-site.htm

If you read 4. point as:

If you have centralized logging configured, make a backup of the centralized logging database by running the following command:

pg_dump.exe -h localhost -p 4432 -U postgres -b -F t -f "c:\Qlogs_backup.tar" Qlogs

So I have taken the backup of Centralized logging by above command but can you please help me to know how to restore this backup ? Becuase on restore page, there is no say about this point.

https://help.qlik.com/en-US/sense/June2018/Subsystems/PlanningQlikSenseDeployments/Content/Deployment/Backing-up-a-site.…

Thanks,

Rohit

Re: How to restore centralized logging database

kaushiknsolanki — Tue, 04 Sep 2018 06:47:57 GMT

Hi,

The Log restoration process is similar to the the one used for restoring the repository.

Keep one thing in mind, just change the zip file name.

Regards,

Kaushik Solanki

Re: How to restore centralized logging database

Levi_Turner — Tue, 04 Sep 2018 09:19:15 GMT

Hey Rohit,

As Kaushik mentioned, it's functionally the same as restoring the QSR database. So something like this:

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

Hope that helps.