topic Re: Backup postgreSQL without stopping servises in Management & Governance

Backup postgreSQL without stopping servises

Anonymous — Wed, 11 Apr 2018 12:11:18 GMT

n/a

Re: Backup postgreSQL without stopping servises

m_s — Wed, 11 Apr 2018 15:36:26 GMT

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

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

Re: Backup postgreSQL without stopping servises

Levi_Turner — Wed, 11 Apr 2018 20:26:08 GMT

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.

Re: Backup postgreSQL without stopping servises

Anonymous — Thu, 12 Apr 2018 09:20:02 GMT

So it can be used t restore ?

Re: Backup postgreSQL without stopping servises

Anonymous — Thu, 12 Apr 2018 09:20:09 GMT

So it can be used t restore ?

Re: Backup postgreSQL without stopping servises

QlikMaster1 — Wed, 04 May 2022 14:36:56 GMT

Hi, whilst this is a very old thread, thought id provide some clarity and @Levi_Turner can correct me, but what he is saying is yes, your fine to backup the database, but you will need to take also a valid back of your qlik route directly, so where the apps, connectors , static data lives to ensure a fully viable restore.

That is what he meant by Disk + DB backups.