Backup to Postgres QSR not finished

[Gabriel_Araya]

Hi Techies ... 

I need to do an upgrade of my Qlik Sense Enterprise in Windows. The first step is to take a backup of Postgres.

Following of documentation .. these commands ran ok:

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

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

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

But, When I run the pg_dump.exe -h localhost -p 4432 -U postgres -b -F t -f "c:\QSR_backup.tar" QSR command, this command never finished, I have wait a couple of hour and after that I kill de Command Prompt window, The file TAR is created but it is open by the pg_dump command.

Any idea? I need this backup before to start the upgrade process ..

Thanks in Advance,

Gabriel 

[mpc]

Hi, 

Can you try to execute the following command before the QSR backup ? 

pg_dump.exe -h localhost -p 4432 -U postgres -v -b -F t -T _deletedentitylog -f "E:\backup\QSR_Backup.tar" QSR 

Kind regards

[Gabriel_Araya]

Hi,

Thanks, We will run the command in the day .. I will keep update.

Best Regards,