Backup to Postgres QSR not finished

Gabriel_Araya — Tue, 22 Oct 2024 22:31:04 GMT

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

Re: Backup to Postgres QSR not finished

mpc — Wed, 23 Oct 2024 06:37:06 GMT

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

Re: Backup to Postgres QSR not finished

Gabriel_Araya — Wed, 23 Oct 2024 12:06:31 GMT

Hi,

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

Best Regards,

topic Backup to Postgres QSR not finished in Management & Governance

Backup to Postgres QSR not finished

Re: Backup to Postgres QSR not finished

Re: Backup to Postgres QSR not finished