How to restore centralized logging database

[rohitk1609]

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/Depl...

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/Deploymen...

Thanks,

Rohit

[kaushiknsolanki]

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

[Levi_Turner]

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.