Backing up PostGres database without stopping Qlik services on Windows server

[HI6]

Qlik sense enterprise (Nov 2021), backup of Qlik nodes including database. Can PostGREs database be backed up without stopping the Qlik Sense services. I understand, stopping services will allow clean backup. We want to perform regular backup automatically without the need to stop services.

Customer Environment

Operating System: Windows server 2016 standard
Operating System Version: 10.0.14393 Build 14393
Product Release: November 2021 Patch 12
Environment Type: On premise, 5 engines, 4 proxies, 2 postgres db server, QVDs on NAS

[Albert_Candelario · Accepted solution]

Hello @HI6 ,

Thanks for posting.

What is the requirement on not stopping the services as such could also be automated like for example:

@ECHO OFF
net stop "Qlik Sense Engine Service"
net stop "Qlik Sense Printing Service"
net stop "Qlik Logging Service"
net stop "Qlik Sense Proxy Service"
net stop "Qlik Sense Scheduler Service"
net stop "Qlik Sense Repository Service"
net stop "Qlik Sense Service Dispatcher"
net stop "Qlik Sense Repository Database"

Also notice the Repository Database does not need to be stopped.

Backing up a Qlik Sense site ‒ Qlik Sense for administrators

Cheers,

Albert