Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

s_dougaz
New Contributor

Backup postgreSQL without stopping servises

n/a

4 Replies
m_schindler
Contributor II

Re: Backup postgreSQL without stopping servises

Hello Sana,

I just tried that in our development enviroment and there were no issues so I think it just works .

You can backup your database with the following commands:

Open cmd.exe

Change directory to PostgreSQL:

     cd %ProgramFiles%\Qlik\Sense\Repository\PostgreSQL\9.3\bin

OR

     cd %ProgramFiles%\Qlik\Sense\Repository\PostgreSQL\9.6\bin

Create Backup (need to enter your repository password):

     pg_dump.exe -h localhost -p 4432 -U postgres -b -F t -f "c:\backup\QSR_backup.tar" QSR

Cheers,

Mathias

Employee
Employee

Re: Backup postgreSQL without stopping servises

You do not need to stop Qlik Sense services to get a backup of the Repository Database. PostgreSQL can handle queuing any transactions until the dump is complete. So the result is a valid .TAR file backup.

The concern with this method is that you really do need to stop services to take a back up of the apps used by Qlik Sense. Our Engine process does not queue transactions for a full restore you need a copy of the binary from disk + the DB from a single point in time for reliable results.

s_dougaz
New Contributor

Re: Backup postgreSQL without stopping servises

So it can be used t restore ?

s_dougaz
New Contributor

Re: Backup postgreSQL without stopping servises

So it can be used t restore ?

Community Browser